File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/DMC/programi/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");
	$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"])."'"); 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`) VALUES 
('$emertimi','$dt_a','$cpatvsh','$njesia_shto','$sasia','0','$tvshja','$barkodi')"); 
	$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']);
$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'"));
$rsow = mysql_fetch_array(mysql_query("select *  from perdorues where id = '$_SESSION[userid]'")); 
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' ");
}
elseif($product_code !="")	
{
$prod = mysql_query("SELECT * FROM produkte where barkodi='$product_code' AND aktiv = '1' ");
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' WHERE invoice='$_SESSION[userid]-$recet_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'";
$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', discount='$skonto'WHERE invoice='$_SESSION[userid]-$recet_id' AND product='$product_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'");
	if(mysql_num_rows($sqlaa) > 0)
	{
		$kka = mysql_fetch_array($sqlaa);
		$sql = mysql_query("UPDATE sales_order SET discount='".$kka["discount"]."',artikulli='".$kka["artikulli"]."',gjendja='".$kka["gjendja"]."', WHERE invoice='$_SESSION[userid]-$recet_id'");
	mysql_query("DELETE from sales_order WHERE invoice='$_SESSION[userid]-$recet_id' AND product = '1' AND name = 'Recete' ");
	}
$sql4 = "INSERT INTO sales_order(invoice,product,qty,amount,name,price,product_code,date,user_id, discount, njesia, tvsh, tipi,artikulli,gjendja) VALUES 
('$_SESSION[userid]-$recet_id','$product_id','$c','$d','$name','$fffffff','$code','$date','$customerid','$skonto','$njesia','$tvsh','$tipi','$artikulli','$gjendja')";
$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>Kujdes ! sasia e <?php echo $row['titulli']; ?> ë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>		
					
<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;
}
.quantity {
  position: relative;
}

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 = " WHERE id IN ($detyra)";} $kat =mysql_query("SELECT * FROM kategorite $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 $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' "); 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'")); 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' 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' 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">Emërtimi</td>
		<td style="min-width:100px;text-align:center;">Sasia</td> 
      <?php if($_SESSION["category"] != "Doktor"){ ?>  
		<td style="min-width:100px;text-align:center;" colspan="2">Cmimi</td>
		<td style="min-width:100px;text-align:center;">Vlera</td>
	 <?php } ?>
	   </tr>  
	   
        <?php $totam=0;$totam2=0;
$skonto_pacient = mysql_fetch_array(mysql_query("SELECT skonto FROM pacient where id='$pacientii'"));
$kursi = mysql_fetch_array(mysql_query("SELECT titulli,artikulli FROM permbledhje where id='4'"));
$result ="SELECT * FROM sales_order WHERE invoice= '$_SESSION[userid]-$recet_id' AND tipi = '$tipi' ORDER BY transaction_id ASC";
$prod = mysql_query($result);
while($row = mysql_fetch_array($prod)){ 
$produkti_monedh = mysql_fetch_array(mysql_query("select monedha from produkte where id = '$row[product]'")); 
if($produkti_monedh['monedha'] =="$"){$ppp=($row['price'] * $kursi["artikulli"]) * 100;}elseif($produkti_monedh['monedha'] =="€"){$ppp=($row['price'] * $kursi["titulli"]) * 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 3px 1px 5px;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($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["category"] != "Doktor"){ ?>
<td style="text-align:center;min-width:80px;"><?php echo number_format($ppp,2); ?></td>
<td style="text-align:center;font-size:9px; font-weight:bold;min-width:20px;">/<?php echo $row["njesia"]; ?></td>
<td style="text-align:center;"><?php echo number_format($pppa,2); ?></td><?php } ?>
<?php $totam += $pppa; $totam2 += $pppa2; ?>
        </tr>
        <?php } ?>
	    </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="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ë">Lekë</option><?php } ?>
<option value="€">€</option>
<option value="$">$</option>
</select><select id="metoda_pageses" 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">Kesh</option><?php } ?>
<option value="Bank">Bank</option>
<option value="Debit">Debit</option>
</select></td><?php } ?><td style="border: none; none;min-width: 100px; font-size:11px; font-weight:bold; color:green;"><?php $euro = ($totam2  / 100) / $kursi["titulli"];  $dollar = ($totam2 / 100) / $kursi["artikulli"]; 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>

</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'; }
		 mysql_query("INSERT INTO `fatura`(`data`, `user_id`, `shitur_nga`, `totali`, `skonto`, `pacient_id`, `metoda_pageses`, 
		 `arka`, `orari_arkes`,`total_skonto`,`monedha`,`euro`,`dollar`) VALUES('$dt_a',
			'$_SESSION[userid]','$tipi','$totam2','$sko','$pacientii','$metoda_pageses','$aaaaa','$dt_ora','$total_skonto'
			,'$monedha','$euro','$dollar')");
			 $faturidd = mysql_insert_id();
	echo mysql_error();$emri_pacientit = mysql_fetch_array(mysql_query("SELECT emri FROM pacient where id='$pacientii'"));
			 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')");
		while($zgjidhrow = mysql_fetch_array($zgjidh)){
$produkti_monedh = mysql_fetch_array(mysql_query("select monedha from produkte where id = '$zgjidhrow[product]'")); 
if($produkti_monedh['monedha'] =="$"){$tot=(($zgjidhrow['price'] * $kursi["artikulli"]) * 100) * $zgjidhrow["qty"];}elseif($produkti_monedh['monedha'] =="€"){$tot=(($zgjidhrow['price'] * $kursi["titulli"]) * 100) * $zgjidhrow["qty"];}else{$tot=$zgjidhrow['price']  * $zgjidhrow["qty"];}
$tek_dollar = ($tot / 100) / $kursi["artikulli"];
 $tek_euro = ($tot / 100) / $kursi["titulli"];
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`) VALUES('$zgjidhrow[product]','$pacientii', '$_SESSION[userid]','$dt_a',
'$zgjidhrow[qty]','$sko','1','$tipi','$tot','$recet_id',' $faturidd','$metoda_pageses','$dt_ora','$total_skonto','$monedha','$tek_euro','$tek_dollar')");
	$ing=mysql_query("SELECT * FROM ingredientet WHERE produkt_id= '$zgjidhrow[product]'");
		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`) 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')");
$inasdasd = mysql_fetch_array(mysql_query("SELECT sasi_recepture,shitur_heren_e_fundit,masa,sasia from produkte where id = '$ingreditnt[ingredient_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]'");
		}
	echo mysql_error();} mysql_query("DELETE FROM sales_order where invoice='$_SESSION[userid]-$recet_id' AND tipi = '$tipi'");}
	if(isset($_POST["printo"]) && $_POST["tipi"] == "Doktor"){
$protokolli = date("Y");
mysql_query("INSERT INTO `receta_pacientesh`(`user_id`, `pacient_id`, `artikulli`, `data`, `skonto`, `radha`, `perpunimi`, `arka`, `gjendja`, `protokolli`)
VALUES ('$_SESSION[userid]','$recet_id','$artikulli','$dt_ora','$sko','$radha','1','1','$gjendja','$protokolli')");
$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'");
		 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`) 
		 VALUES('$dt_a','0','$_SESSION[userid]','$tipi + Arka','$totam2','$sko','$rec_r_id','$recet_id','$metoda_pageses','$total_skonto','$monedha','$euro','$dollar')");
			 $faturidd = mysql_insert_id();
		$emri_pacientit = mysql_fetch_array(mysql_query("SELECT emri FROM pacient where id='$recet_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'");
		while($zgjidhrow = mysql_fetch_array($zgjidh)){
$produkti_monedh = mysql_fetch_array(mysql_query("select monedha from produkte where id = '$zgjidhrow[product]'")); 
if($produkti_monedh['monedha'] =="$"){$tot=(($zgjidhrow['price'] * $kursi["artikulli"]) * 100) * $zgjidhrow["qty"];}elseif($produkti_monedh['monedha'] =="€"){$tot=(($zgjidhrow['price'] * $kursi["titulli"]) * 100) * $zgjidhrow["qty"];}else{$tot=$zgjidhrow['price']  * $zgjidhrow["qty"];}
$tek_dollar = ($tot / 100) / $kursi["artikulli"];
 $tek_euro = ($tot / 100) / $kursi["titulli"];
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`) VALUES('$zgjidhrow[product]','$recet_id', '0','$_SESSION[userid]','$dt_a',
'$zgjidhrow[qty]','$sko','1','$tipi + Arka','$tot','$rec_r_id',' $faturidd','$metoda_pageses','$total_skonto','$monedha','$tek_euro','$tek_dollar')");
	$ing=mysql_query("SELECT * FROM ingredientet WHERE produkt_id= '$zgjidhrow[product]'");
	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`) VALUES('$ingreditnt[ingredient_id]','$pacientii','0','$_SESSION[userid]','$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')");
$inasdasd = mysql_fetch_array(mysql_query("SELECT sasi_recepture,shitur_heren_e_fundit,masa,sasia from produkte where id = '$ingreditnt[ingredient_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]'");
		}
	echo mysql_error();} mysql_query("DELETE FROM sales_order where invoice='$_SESSION[userid]-$recet_id' AND tipi = '$tipi'");} ?>
<?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"])."'"); 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"])."'"); exit(); } ?>
<style>.chosen-container { background: white; width:100% !important;} </style>

Batal

⬅ Naik ke programi 13 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 22:43	✏️ Edit 👁️ View
🐘check_and_send_sms_urimi.php	php	2.9 KB	2018-04-12 02:00	✏️ Edit 👁️ View
🐘connect.php	php	368 B	2018-04-09 02:13	✏️ Edit 👁️ View
🐘db_conx.php	php	287 B	2018-05-09 12:55	✏️ Edit 👁️ View
🐘dbconnect.php	php	1.6 KB	2018-05-25 03:26	✏️ Edit 👁️ View
🐘dental_pos.php	php	104.6 KB	2018-08-16 01:01	✏️ Edit 👁️ View
📄error_log	file	785.6 KB	2019-09-26 23:54	✏️ Edit 👁️ View
🐘image_resize.php	php	1.5 KB	2017-12-06 12:40	✏️ Edit 👁️ View
🐘model_posi.php	php	29 KB	2018-09-05 17:22	✏️ Edit 👁️ View
🐘savesales.php	php	47.1 KB	2018-08-08 16:05	✏️ Edit 👁️ View
🐘smsGateway.php	php	2.9 KB	2018-05-14 15:36	✏️ Edit 👁️ View
🐘status.php	php	2.8 KB	2018-06-25 23:54	✏️ Edit 👁️ View