File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/DMC/programi/Nklinik_php_files/savesales.php

<?php
error_reporting(E_ALL);
include_once("status.php");
$dt_a = date("Y-m-d H:i:s");
$data_sotme = date("Y-m-d");
define('INCLUDE_CHECK',1);
include "dbconnect.php";
if(isset($_GET["col"]) && isset($_GET["table"]) && isset($_GET["tipi"]))
{
	$kot="";
 $col = preg_replace('#[^A-Za-z0-9 _-]#', '',$_GET["col"]);  
 $tipi = preg_replace('#[^A-Za-z0-9-_ ]#', '',$_GET["tipi"]);  
  $table = preg_replace('#[^0-9A-Za-z. -_,]#', '',$_GET["table"]); 
	if($table=="fatura" && $tipi == "arka"){$kot=" OR arka ='0'";}
 $sql = mysql_fetch_array(mysql_query("SELECT COUNT(id) as countedid from $table WHERE $col = '0' $kot"));
  echo "<b>(".$sql["countedid"].")</b>"; 
exit();
}
if(isset($_POST["tipi"]) && isset($_POST["idfatures"])){
	if($_POST["arsyeja"] !="" && $_POST["arsyeja"] !=" "){
  $tipi = preg_replace('#[^A-Za-z0-9_]#', '',$_POST["tipi"]);  
 $idfatures = preg_replace('#[^0-9]#', '',$_POST["idfatures"]);
  $arsyeja = strip_tags($_POST["arsyeja"]);
 $statusi="1";
 if($tipi == "anullo_faturen"){$statusi="0";}
		$kontrollo_per_kest = mysql_fetch_array(mysql_query("SELECT id_fatures,id,totali,euro,dollar FROM fatura WHERE id= '$idfatures'"));
		if($kontrollo_per_kest["id_fatures"] !="0"){
		 $sql = mysql_query("UPDATE fatura SET statusi_fatures = '$statusi' WHERE id = '$idfatures'");
			if($tipi == "anullo_faturen"){
				$sql = mysql_query("UPDATE fatura SET totali = totali + '$kontrollo_per_kest[totali]', euro = euro + '$kontrollo_per_kest[euro]', dollar = dollar + '$kontrollo_per_kest[dollar]'  WHERE id = '$kontrollo_per_kest[id_fatures]'");
			}else{
				$sql = mysql_query("UPDATE fatura SET totali = totali - '$kontrollo_per_kest[totali]', euro = euro - '$kontrollo_per_kest[euro]', dollar = dollar - '$kontrollo_per_kest[dollar]'  WHERE id = '$kontrollo_per_kest[id_fatures]'");
			}
		}else{
 $sql = mysql_query("UPDATE fatura SET statusi_fatures = '$statusi' WHERE id = '$idfatures'");
 $sql2 = mysql_query("UPDATE produkte_te_shitura SET statusi_fatures = '$statusi' WHERE fature_id = '$idfatures'");
$zgjidh = mysql_query("SELECT * FROM produkte_te_shitura WHERE fature_id= '$idfatures')");
while($zgjidhrow = mysql_fetch_array($zgjidh)){
			if($zgjidhrow["njesia"] !="Copë"){ $assssdd = "0.".$zgjidhrow['sasia']; }else{  $assssdd = $zgjidhrow['sasia']; }
$kontorrli = array_shift(explode(" -",$zgjidhrow["shenime"]));
if($tipi == "anullo_faturen"){
if($kontorrli == "Ingredient"){
mysql_query("UPDATE `produkte` SET `shitur_heren_e_fundit` =`shitur_heren_e_fundit`-'$assssdd' `sasia` = `sasia` + '$assssdd' where id = '$zgjidhrow[produkt_id]'");
}else{
mysql_query("UPDATE `produkte` SET `shitur_heren_e_fundit` =`shitur_heren_e_fundit`-'$assssdd' `sasia` = `sasia` + '$assssdd' where id = '$zgjidhrow[produkt_id]'");
}
}
else
{
	if($kontorrli == "Ingredient"){
if($zgjidhrow["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 = '$zgjidhrow[produkt_id]'");
}else{
}
}
}}
$sql = mysql_query("INSERT INTO `arsye`(`fature_id`, `user_id`, `arsyeja`, `statusi`) VALUES('$idfatures','$_SESSION[userid]','$arsyeja','$statusi')");
echo "Veprimi u krye me sukses!";
	}else{echo "Ky veprim nuk mund të kryhet pa dhënë një arsye!";}
exit();
}
if(isset($_POST["anullo"]) || isset($_POST["aktivizo"]))
{

$anullo = preg_replace('#[^0-9]#', '',$_POST["anullo"]);  
 $aktivizo = preg_replace('#[^0-9]#', '',$_POST["aktivizo"]);
 $tedhenatakim = mysql_fetch_array(mysql_query("SELECT doktori,pacient_id,date,start,id from takime where id = '$anullo' OR id = '$aktivizo'")); 
 $tedhenadok = mysql_fetch_array(mysql_query("SELECT emri, cel, sms from perdorues where kategoria='Doktor' AND id = '$tedhenatakim[doktori]'")); 
 $tedhenapacient = mysql_fetch_array(mysql_query("SELECT emri, cel, sms from pacient where id = '$tedhenatakim[pacient_id]'"));  
 		$new_url = get_tiny_url($linku["enartikulli"].'/anullokonfirmotakim.php?tid='.$tidd.'&did='.$doktor);
$em = explode(" ",$tedhenadok["emri"]);
if($em[0] == "Dr."){ $emri_doktorit = $em[0]." ".$em[1];}else{$emri_doktorit = $em[0];}
$mbiemri_doktorit = end($em);
$nr_doktorit =$tedhenadok['cel'];
$daten = date("d.m.Y",strtotime($tedhenatakim["date"]));
$oren = substr($tedhenatakim["start"],0,5);
$rrr = explode(" ", $tedhenapacient["emri"]);
$emri_pacientit = $rrr[0];
$mbiemri_pacientit = $rrr[1];
$nr_pacientit = $tedhenapacient["cel"];
if(empty($anullo) && !empty($aktivizo)){
$asdddr ='1'; $anullo = $aktivizo; $veprim = "  , riaktivizuar_nga = '$_SESSION[userid]'";
$msg_doktor = mysql_fetch_array(mysql_query("SELECT artikulli FROM kujtese where id='7'"));
$doktor_sms = rregullo_sms($msg_doktor["artikulli"], $emri_doktorit, $mbiemri_doktorit, $nr_doktorit, $daten, $oren, $emri_pacientit, $mbiemri_pacientit, $nr_pacientit).' '.$new_url;
$msg_doktor = mysql_fetch_array(mysql_query("SELECT artikulli FROM kujtese where id='8'"));
$pacient_sms = rregullo_sms($msg_doktor["artikulli"], $emri_doktorit, $mbiemri_doktorit, $nr_doktorit, $daten, $oren, $emri_pacientit, $mbiemri_pacientit, $nr_pacientit);
	$tipi_sms = "Aktivizo Takimin";
}elseif(!empty($anullo) && empty($aktivizo)){$asdddr ='0'; $veprim = " , anulluar_nga = '$_SESSION[userid]'";
$msg_doktor = mysql_fetch_array(mysql_query("SELECT artikulli FROM kujtese where id='9'"));
$doktor_sms = rregullo_sms($msg_doktor["artikulli"], $emri_doktorit, $mbiemri_doktorit, $nr_doktorit, $daten, $oren, $emri_pacientit, $mbiemri_pacientit, $nr_pacientit);
$msg_doktor = mysql_fetch_array(mysql_query("SELECT artikulli FROM kujtese where id='10'"));
$pacient_sms = rregullo_sms($msg_doktor["artikulli"], $emri_doktorit, $mbiemri_doktorit, $nr_doktorit, $daten, $oren, $emri_pacientit, $mbiemri_pacientit, $nr_pacientit);
$tipi_sms = "Anullo Takimin";
} 
$sql = mysql_query("UPDATE takime SET statusi = '$asdddr' $veprim WHERE id = '$anullo'");
if($tedhenadok["sms"] =="1"){ $result = mysql_query("INSERT INTO `rikujtim_me_sms`(`sms`, `doktor_id`, `data`, `derguar`, `nr_celi`, `tipi_sms`) VALUES('$doktor_sms','$tedhenatakim[doktori]','$dt_a','0','$nr_doktorit','$tipi_sms')"); }
if($tedhenapacient["sms"] =="1"){ $result = mysql_query("INSERT INTO `rikujtim_me_sms`(`sms`, `pacient_id`, `data`, `derguar`, `nr_celi`, `tipi_sms`) VALUES('$pacient_sms','$tedhenatakim[pacient_id]','$dt_a','0','$nr_pacientit','$tipi_sms')"); }
  if($sql){echo"Veprimi u krye me sukses!";}else{ echo "Error : ".mysql_error();}
exit();
}
if(isset($_POST["update_id"]) && isset($_POST["update_dk_id"]))
{
 $update_id = preg_replace('#[^0-9]#', '',$_POST["update_id"]);  
  $update_dk_id = preg_replace('#[^0-9]#', '',$_POST["update_dk_id"]); 
 $sql = mysql_query("UPDATE takime SET doktori = '$update_dk_id', transferuar_nga = '$_SESSION[userid]' WHERE id = '$update_id'");
  if($sql){echo"Veprimi u krye me sukses!";}else{ echo "Error : ".mysql_error();}
exit();
}
if(isset($_POST["column_name"]) && isset($_POST["id"])){
  $id = preg_replace('#[^0-9-]#', '',$_POST["id"]);  
  $text = mysql_real_escape_string($_POST["text"]); 
  $column_name = preg_replace('#[^0-9A-Za-z.-_]#', '',$_POST["column_name"]); 
  $dhembet3 = strip_tags($_POST["dhembet3"]);	
	if($column_name == "price"){  $sql = mysql_query("UPDATE sales_order SET price = '$text', amount = qty * '$text'  WHERE transaction_id='".$id."'");
echo mysql_error(); exit(); }
 if($column_name == "qty"){
	 if($text < 1){ $text = 1;}
 $sql = mysql_query("UPDATE sales_order SET qty='".$text."' WHERE transaction_id='".$id."'");
echo mysql_error(); exit();
}elseif($column_name == "shenime"){
 $sql = mysql_query("UPDATE sales_order SET shenime='".$text."' WHERE transaction_id='".$id."'");
echo mysql_error(); exit();
}elseif($column_name == "skonto" || $column_name == "gjendja" || $column_name == "artikulli" || $column_name == "dhembet"){ 
	if($column_name == "skonto"){  
	$sqlaa = mysql_query("SELECT transaction_id from sales_order WHERE invoice='".$id."'");
		$rsow = mysql_fetch_array(mysql_query("select skonto from perdorues where id = '$_SESSION[userid]'"));
	if($text > $rsow["skonto"]){$text= $rsow["skonto"]; }
	if($text == 0){ $text ="";}
	if(mysql_num_rows($sqlaa) > 0){
$sql = mysql_query("UPDATE sales_order SET discount='".$text."' WHERE invoice='".$id."'");
	}else
{echo $text;
	if(!empty($text)){
$sql = mysql_query("INSERT INTO sales_order(invoice,product,qty,amount,name,price,product_code,user_id, discount, njesia, tvsh, tipi,dhembet) VALUES ('$id','1','1','0','Recete','0','0','0','$text','0','0','Doktor','$dhembet3')");	
}}
}
else{
	
if($column_name == "dhembet"){ $sql = mysql_query("UPDATE sales_order SET $column_name='".$text."' WHERE transaction_id='".$id."'"); exit(); }
	$sqlaa = mysql_query("SELECT transaction_id from sales_order WHERE invoice='".$id."'");
	if(mysql_num_rows($sqlaa) > 0){
	$sql = mysql_query("UPDATE sales_order SET $column_name='".$text."' WHERE invoice='".$id."'");
}else
{
	if(!empty($text)){
$sql = mysql_query("INSERT INTO sales_order(invoice,product,qty,amount,name,price,product_code,user_id, discount, njesia, tvsh, tipi, $column_name, dhembet) VALUES 
('$id','1','1','0','Recete','0','0','0','','0','0','Doktor','$text','$dhembet3')");	
}} }
echo mysql_error(); exit();
}elseif($column_name == "skonto_fature"){
	$rsow = mysql_fetch_array(mysql_query("select skonto from perdorues where id = '$_SESSION[userid]'"));
	$kursi = mysql_fetch_array(mysql_query("SELECT titulli,artikulli FROM permbledhje where id='4'"));
	if($text > $rsow["skonto"]){$text= $rsow["skonto"]; }
	$result ="SELECT * FROM produkte_te_shitura WHERE fature_id= '".$id."'";
$prod = mysql_query($result);
$totali = 0;
$totali_skontos = 0;
$euro=0;
$dollar = 0;
$zbrit = 0;
 $tek_dollar =0;
  $tek_euro =0;
while($row = mysql_fetch_array($prod)){ 
$produkti_monedh = mysql_fetch_array(mysql_query("select cmimi_shitjes,monedha from produkte where id = '$row[produkt_id]'")); 
if($produkti_monedh['monedha'] =="$"){$ppp=($produkti_monedh['cmimi_shitjes'] * $kursi["artikulli"]) * 100;}elseif($produkti_monedh['monedha'] =="€"){$ppp=($produkti_monedh['cmimi_shitjes'] * $kursi["titulli"]) * 100;}else{$ppp=$produkti_monedh['cmimi_shitjes'];}
 $pppa2= ($ppp - ($ppp * ($text / 100))) * $row['sasia'];
 $tek_dollar = ($pppa2 / 100) / $kursi["artikulli"];
 $tek_euro = ($pppa2 / 100) / $kursi["titulli"];
 $euro +=$tek_euro;
 $dollar +=$tek_dollar;
  $zbrit = ($ppp * ($text / 100)) * $row['sasia'];
 $totali += $pppa2;
 $totali_skontos += $zbrit;
 $sql = mysql_query("UPDATE produkte_te_shitura SET skonto ='".$text."', cmimi ='".$pppa2."', euro ='".$tek_euro."', dollar ='".$tek_dollar."', total_skonto ='".$zbrit."' WHERE id='".$row['id']."'");
}
 $sql = mysql_query("UPDATE fatura SET skonto ='".$text."', totali ='".$totali."', euro ='".$euro."', dollar ='".$dollar."', total_skonto ='".$totali_skontos."' WHERE id='".$id."'");
}else{
	 if($column_name == "skonto_pacienti"){$column_name ="skonto";} 
 $ishte = mysql_fetch_array(mysql_query("SELECT $column_name FROM pacient where id='$id'"));
	 $siishte = $ishte[$column_name];
	 $sql = mysql_query("UPDATE pacient SET $column_name='".$text."' WHERE id='".$id."'");
	 if($siishte != $text){
	  mysql_query("INSERT INTO `ndryshime_kartele`(`kolona`, `ishte`, `ube`, `user_id`, `pacient_id`, `data`) VALUES('$column_name','$siishte','$text','$_SESSION[userid]','$id','$dt_a')"); }
if($sql){echo '<div class="asdw alert alert-success alert-dismissible fade in mb-2" role="alert" style="margin-bottom: 5px !important;  background-color: #7dd368 !important;">
<button type="button" style="font-size: 25px;right: -1.5rem;margin-top: -2.5px;" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>
<strong style="font-size: 15px;color: white;"><i class="icon-check" style="border: 1px solid white;padding: 5px;border-radius: 50%;margin-right: 11px;"></i> Ndryshimet u ruajten me sukses! </strong></div><script type="text/javascript">
setTimeout(function() { $(".asdw").fadeOut(1000); }, 2000)</script>';}else{echo mysql_error();} }
exit();
}
if(isset($_POST["kerkesa_specifike"]) && isset($_POST["id"]))
{
 $id = preg_replace('#[^0-9]#', '',$_POST["id"]);  
 $text = preg_replace('#[^0-9A-Za-z. -_,]#', '',$_POST["text"]); 
 $sql = mysql_query("UPDATE kerkesa_specifike SET gati='".$text."' WHERE id='".$id."'");
 exit();
}
if(isset($_POST["motorristi"]) && isset($_POST["faturat"]) && isset($_POST["print"])){
	$metoda_pageses = preg_replace('#[^0-9A-Za-z]#', '',$_POST["metoda_pageses"]); 
	$motorristi = preg_replace('#[^0-9]#', '',$_POST["motorristi"]);
	$kesti = preg_replace('#[^0-9 .,]#', '',$_POST["kesti"]);
	$pagese_me_keste = preg_replace('#[^0-9]#', '',$_POST["pagese_me_keste"]);  
	$monedha = strip_tags($_POST["monedha"]);  
	$shenime = strip_tags($_POST["shenime"]);  
	$fat = explode(",",implode(",",$_POST["faturat"]));
	$print = preg_replace('#[^0-9]#', '',$_POST["print"]);  
	foreach($fat as $fature){
	 $id = preg_replace('#[^0-9]#', '',$fature);  
		if($pagese_me_keste == '1'){
$kursi = mysql_fetch_array(mysql_query("SELECT titulli,artikulli FROM permbledhje where id='4'"));
$te_dhenat_e_fatures = mysql_fetch_array(mysql_query("SELECT * FROM fatura where id ='$id'"));
	if($monedha == 'Lekë'){ 
		$totali_lekeve = $kesti; 
		$euro = ($kesti  / 100) / $kursi["titulli"]; 
		$dollar = ($kesti / 100) / $kursi["artikulli"]; 
			$mbetja_leke = $te_dhenat_e_fatures["totali"] - $kesti;
			$mbetja_euro = $te_dhenat_e_fatures["euro"] - $euro;
			$mbetja_dollar = $te_dhenat_e_fatures["dollar"] - $dollar;
	}
    if($monedha == '€'){ 
		$euro = $kesti; 
		$totali_lekeve = ($kesti * 100) * $kursi["titulli"]; 
		$dollar = ($totali_lekeve / 100) / $kursi["artikulli"]; 
		$mbetja_leke = $te_dhenat_e_fatures["totali"] - $totali_lekeve;
			$mbetja_euro = $te_dhenat_e_fatures["euro"] - $euro;
			$mbetja_dollar = $te_dhenat_e_fatures["dollar"] - $dollar;
	}
    if($monedha == '$'){ 
		$dollar = $kesti; 
		$totali_lekeve = ($kesti * 100) * $kursi["artikulli"]; 
		$euro = ($totali_lekeve / 100) / $kursi["titulli"];
		    $mbetja_leke = $te_dhenat_e_fatures["totali"] - $totali_lekeve ;
			$mbetja_euro = $te_dhenat_e_fatures["euro"] - $euro;
			$mbetja_dollar = $te_dhenat_e_fatures["dollar"] - $dollar;
	}
	
mysql_query("INSERT INTO `pagesat_me_keste`(`fature_id`, `pacient_id`, `user_id`, `doktor_id`, `cmimi_paguar`, `euro`, `dollar`, `monedha`, `metoda`, `mbetja_leke`, `mbetja_euro`, `mbetja_dollar`, `kursi_euro`, `kursi_dollar`, `shenime`) VALUES ('$id','$te_dhenat_e_fatures[pacient_id]','$_SESSION[userid]','$te_dhenat_e_fatures[doktor_id]','$totali_lekeve','$euro','$dollar','$monedha','$metoda_pageses','$mbetja_leke','$mbetja_euro','$mbetja_dollar','$kursi[titulli]','$kursi[artikulli]','$shenime')"); 
			
mysql_query("UPDATE fatura SET totali ='$mbetja_leke',euro ='$mbetja_euro',dollar ='$mbetja_dollar' WHERE id='".$id."'");
			
mysql_query("INSERT INTO `fatura`(`data`, `user_id`, `shitur_nga`, `totali`, `skonto`, `pacient_id`, `arka`, `perdoruesi_arkes`, `orari_arkes`, `doktor_id`, `recete_id`, `metoda_pageses`, `print`, `total_skonto`, `monedha`, `euro`, `dollar`, `statusi_fatures`, `pagese_me_keste`, `id_fatures`, `shenime`) VALUES ('$dt_a','$_SESSION[userid]','$te_dhenat_e_fatures[shitur_nga]','$totali_lekeve','$te_dhenat_e_fatures[skonto]','$te_dhenat_e_fatures[pacient_id]','1','$_SESSION[userid]','$dt_a','$te_dhenat_e_fatures[doktor_id]','$te_dhenat_e_fatures[recete_id]','$metoda_pageses','$print','$te_dhenat_e_fatures[total_skonto]','$monedha','$euro','$dollar','1','1','$id','$shenime')");
			if($te_dhenat_e_fatures[totali] <= $totali_lekeve){
			$sql = mysql_query("UPDATE fatura SET arka='1',motorristi = '$motorristi',metoda_pageses = '$metoda_pageses',monedha = '$monedha',print = '$print',orari_arkes = '$dt_a', user_id = '$_SESSION[userid]', perdoruesi_arkes = '$_SESSION[userid]',pagese_me_keste ='$pagese_me_keste' WHERE id='".$id."'");
	$sql = mysql_query("UPDATE produkte_te_shitura SET arka='1',user_id = '$_SESSION[userid]',metoda_pageses = '$metoda_pageses',print = '$print' WHERE fature_id='".$id."'");
		
	$sqlssss = mysql_query("SELECT produkt_id,sasia from produkte_te_shitura WHERE fature_id='".$id."'");
	while($sqlsd =mysql_fetch_array($sqlssss)){	mysql_query("UPDATE produkte SET sasi_shitur=sasi_shitur +'$sqlsd[sasia]' WHERE id='".$sqlsd['produkt_id']."'");}}
		
		}else{
				$sql = mysql_query("UPDATE fatura SET arka='1',motorristi = '$motorristi',metoda_pageses = '$metoda_pageses',monedha = '$monedha',print = '$print',orari_arkes = '$dt_a', user_id = '$_SESSION[userid]', perdoruesi_arkes = '$_SESSION[userid]',pagese_me_keste ='$pagese_me_keste' WHERE id='".$id."'");
	$sql = mysql_query("UPDATE produkte_te_shitura SET arka='1',user_id = '$_SESSION[userid]',metoda_pageses = '$metoda_pageses',print = '$print' WHERE fature_id='".$id."'");
		
	$sqlssss = mysql_query("SELECT produkt_id,sasia from produkte_te_shitura WHERE fature_id='".$id."'");
	while($sqlsd =mysql_fetch_array($sqlssss)){	mysql_query("UPDATE produkte SET sasi_shitur=sasi_shitur +'$sqlsd[sasia]' WHERE id='".$sqlsd['produkt_id']."'");}}
	}
	
	if($print == 99){ 
	foreach($fat as $faa){ ?>
	<center ><img src="images/logo.png" style="height:80px; width:auto; margin:0 auto;">
		<div style="position:absolute;right: 10px;top: 35px;text-align:left;width:200px;">
			<span style="font-weight:bold; font-size:12px;">Nuis: L72030010S</span></br>
		<span style="font-weight:bold; font-size:12px;">Liçencë: LN-3854-09-2017</span></div>
	<div style="margin-top:10px;font:bold 20px 'Aleo';">Faturë</div>
    <?php// echo $linku["slide"]; ?><div style="text-align:left;font-size:10px; font-weight:bold">Tiranë, <?php echo date("d.m.Y"); ?></div><br><br>	
	</center>
	<table style="font-family: arial;font-size: 12px;text-align:left;width:100%;margin-bottom: 35px;border-bottom: 1px solid black;">
		<tr style="border:none; text-align:left;">
<td style="border:none; text-align:left; font-weight:bold;">Nr. <span id="nrfatures"><?php echo $faa; ?></span></td>
			<td style="border:none; text-align:right;"><?php $pidd = mysql_fetch_array(mysql_query("SELECT pacient_id FROM fatura where id='$id'")); $emri_motorristit = mysql_fetch_array(mysql_query("SELECT emri FROM pacient where id='$pidd[pacient_id]'")); echo $pidd["pacient_id"]." - ".$emri_motorristit["emri"]; ?></td>
		</tr>
	</table>
	<table id="print" style="width:100%;">
      <tbody id="perscroll" style="overflow-y:auto; overflow-x:hidden; width:100%;border-radius:0 !important; background-color:#fff; float:left; border: 1px solid #eaeaea;margin-bottom:0;">
  <tr class="cart__row cart__header-labels" style="border-bottom: 1px solid #eaeaea; font-size:13px;font-weight:bold;">
        <td style="text-align:left !important; padding:7px;">Emërtimi</td>
		<td style="min-width:60px;text-align:center; padding:7px;">Sasia</td>
        <td style="min-width:60px;text-align:center; padding:7px;">Cmimi</td>
		<td style="min-width:60px;text-align:center; padding:7px;">Vlera</td>
        <?php  $result ="SELECT * FROM produkte_te_shitura WHERE fature_id= '$faa' AND tipi IS NULL ORDER BY id ASC";
			$prod = mysql_query($result); echo mysql_error();
			$x = 0; $totam=0;$totam2=0; $koha_totale = 0; $skkonto = 0; 
while($row = mysql_fetch_array($prod)){ $skkonto = $row["skonto"];
$produkt_name = mysql_fetch_array(mysql_query("SELECT titulli FROM produkte where id='$row[produkt_id]'"));?>
<tr class="cart__row table__section" style="border-bottom: 1px solid #eaeaea;font-size:10px;">
<td style="text-align:left !important;padding-bottom:0;width:9%; font-size:12px; padding:5px;"><?php if($row["produkt_id"] !="0"){ echo $produkt_name['titulli'];}else{echo "Recete";} ?>  
<?php if(!empty($row['shenime'])){ ?><p style="text-align:left;font-size:10px;margin-bottom:0; font-weight:bold;"><?php echo $row['shenime']; ?></p><?php } ?></td>
<td style="text-align:center;width:9%; font-size:12px; padding:7px;"><?php echo $row['sasia']; ?></td>
<td style="text-align:center;width:9%; font-size:12px; padding:7px;"><?php $ppp=$row['cmimi']  / $row['sasia']; echo number_format($ppp,2); ?></td>
<td style="text-align:center;width:9%; font-size:12px; padding:7px;"><?php $pppa=$row['cmimi']; 
$pppa2= ($row['cmimi'] - ($row['cmimi'] * ($row["skonto"] / 100))); echo number_format($pppa,2); ?></td>
<?php $totam += $pppa; $totam2 += $pppa2;?>
</tr>
<?php } ?>
<tr  style='border:none;border-top: 2px solid black !important;margin-top:-1px;' id="shumaid" class="cart__row table__section">	
	<?php if($row["shitur_nga"] == "Web"){ ?><td style="min-width:60px;border: none;padding:7px;width:9%;font-size:13px;">Porosi Online <?php if($skkonto > 0){ echo $skkonto; ?>% Skonto<?php } ?></td><?php }else{ ?><td style="border: none;min-width:60px;width:9%;padding:7px;"><?php if($skkonto > 0){ echo $skkonto; ?>% Skonto<?php } ?></td><?php } ?>
	<td style="border: none;padding:7px;min-width:60px;font-size:13px;width:9%;"></td><td style="min-width:<?php if($skkonto > 0){echo"40";}else{echo"70";}?>px;border: none;padding:7px;width:9%;"></td>
<td style="min-width:60px;font-size:13px;text-align:center;padding:7px;width:9%;"><?php if($skkonto > 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>
 </tr> </tbody>
 </table>
	</div>

<div style='border:none; width:100%; font-size:10px; font-weight:bold; margin-top:10px'><?php $kontaktet = mysql_fetch_array(mysql_query("SELECT kontaktet FROM fatura where id='$faa'")); echo $kontaktet["kontaktet"]; ?></div>	  
  
	<div id="footerii" style="margin-top:50px; text-align:center;">
            <span class="" style='padding-right:15px;'>Adresa: <?php echo $linku["artikulli"]; ?></span></br> 
            <span class="" style='padding-right:15px;'>Mobel <?php echo $linku["titulli"]; ?> <img src="images/media.svg" style="width: 25px;margin-top: -3px;"> / <img src="images/instagram-colourful-icon.png" style="width:20px;"> medical center Dybeli Group</span></br> 
 <span class="" style='padding-right:15px;'> Stomatologji - Dermoestetike - Pediatri - Gjinekologji - Fizioterapi - Laborator Mjekësor - Mjek familje </span> </br> 
            <span class="" style='padding-right:15px;'> www.campusiea.com  -  www.dmc.al</span> 
          </div> 
	<?php } ?> <style>@media print{#footerii { position: fixed; bottom: 50px; text-align:center; width:100%;} .footer-content,#koka {display:none !important; }  }</style> <?php }
 exit();
}
if(isset($_POST["table"]) && $_POST["table"] == "fatura" && isset($_POST["mbyll_turnin"]) && $_POST["mbyll_turnin"] == "true" )
{
	$skonto_fature = preg_replace("/[^0-9-]/", "", $_POST['skonto_fature']);
$from= preg_replace("/[^0-9-]/", "", $_POST['from']);
$to= preg_replace("/[^0-9-]/", "", $_POST['to']);
$doktori= preg_replace("/[^0-9]/", "", $_POST['doktori']);
$fatura_te_turnit= preg_replace("/[^0-9]/", "", $_POST['fatura_te_turnit']);
$mbyllur_nga= preg_replace("/[^0-9]/", "", $_POST['mbyllur_nga']);
$fatura_te= preg_replace("/[^a-zA-Z]/", "", $_POST['fatura_te']);
$magazina= preg_replace("/[^0-9]/", "", $_POST['magazina']);
$motorristi= preg_replace("/[^0-9]/", "", $_POST['motorristi']);
$produkte_te= preg_replace("/[^0-9]/", "", $_POST['produkte_te']);
$dyqani= preg_replace("/[^0-9]/", "", $_POST['dyqani']);
$katering_dyqan= preg_replace("/[^0-9]/", "", $_GET['katering_dyqan']);
	$motorristi = preg_replace('#[^0-9]#', '',$_POST["motorristi"]);  
	$print = preg_replace('#[^0-9]#', '',$_POST["print"]);  
	$printuara = preg_replace('#[^0-9]#', '',$_POST["printuara"]);
	$metoda_pageses = preg_replace('#[^0-9]#', '',$_POST["metoda_pageses"]);
	$search = strip_tags($_POST["pagination_setting"]);
$time ="00:00:00"; $time2 ="23:59:59";
	
	$sql = "SELECT * from fatura WHERE id !='0' ";
if(!empty($search))
{
 $sql .= " AND (id LIKE '%$search%' OR user_id LIKE '%$search%' OR totali LIKE '%$search%' OR skonto LIKE '%$search%' OR kontaktet LIKE '%$search%')";		
}
	if(!empty($doktori))
{ 
 $sql .= " AND user_id='$doktori'";	
}
if($fatura_te_turnit !="")
{ 
 $sql .= " AND mbyllur='$fatura_te_turnit'";	
}
if($mbyllur_nga !="")
{ 
 $sql .= " AND mbyllur_nga='$mbyllur_nga'";	
}
	if(!empty($motorristi))
{ 
 $sql .= " AND motorristi='$motorristi'";	
}if($fatura_te !="")
{ 
 $sql .= " AND shitur_nga='$fatura_te'";	
}
if($katering_dyqan !="")
{ 
 $sql .= " AND katering='$katering_dyqan'";	
}
if($skonto_fature !=""){if($skonto_fature =="1"){$sql .= " AND skonto !=''";}else{ $sql .= " AND skonto =''"; }}
if(!empty($dyqani)){  $sql .= " AND dyqan_id='$dyqani'";	}
if($produkte_te !=""){ if($produkte_te =="2"){ $sql .= " AND arka='1' AND orari_arkes <= '$data_sotme 23:59:59' AND orari_arkes >= '$data_sotme 00:00:00'"; }else{ $sql .= " AND arka='$produkte_te'";	}}
if($metoda_pageses !=""){ $sql .= " AND metoda_pageses='$metoda_pageses'";	}
if($printuara !=""){  $sql .= " AND print='$printuara'";	}
if(!empty($from)){ $sql .="AND data >='$from $time'";}
if(!empty($to)){$sql .="AND data <='$to $time2'";} 
	$mysql_query = mysql_query($sql);
	if($print == 1){ 
	while($faa =  mysql_fetch_array($mysql_query))
	{
	?>
	<div style="overflow-x:hidden; margin-bottom:10px;">
	<center ><img src="images/logo.png" style="height:80px; width:auto; margin:0 auto;">
	<div style="margin-top:10px;font:bold 20px 'Aleo';">Faturë</div>
    <?php// echo $linku["slide"]; ?><br><br>	
	</center>
		<table style="font-family: arial; font-size: 12px;text-align:left;">
			<tr style="border-bottom:1px solid black; padding-bottom:10px;">
		<td style="padding-bottom:20px; font-weight:bold;">Nuis: L72030010S</td><td colspan="3"  style="padding-bottom:20px; font-weight:bold;">Liçencë: LN-3854-09-2017</td>
		</tr>
		<tr style="padding:0; border:none; text-align:left;">
			<td style="padding:0; border:none; text-align:left; font-weight:bold; width:70px;">Nr :</td>
			<td id="nrfatures" style="padding:0; border:none; text-align:center; width:250px;"><?php echo $faa["id"]; ?></td>
		</tr>
		<tr style="padding:0; border:none; text-align:left;">
			<td style="padding:0; border:none; text-align:left;font-weight:bold; width:70px;">Data :</td>
			<td style="padding:0; border:none; text-align:center; width:250px;"><?php echo date("d.m.Y H:i:s"); ?></td>
		</tr>
		<tr style="padding:0; border:none; text-align:left;">
			<td style="padding:0; border:none; text-align:left;font-weight:bold; width:70px;">Pacienti :</td>
			<td style="padding:0; border:none; text-align:center; width:250px;"><?php $pidd = mysql_fetch_array(mysql_query("SELECT pacient_id FROM fatura where id='$faa[id]'")); $emri_motorristit = mysql_fetch_array(mysql_query("SELECT emri FROM pacient where id='$faa[pacient_id]'")); echo $faa["pacient_id"]." - ".$emri_motorristit["emri"]; ?></td>
		</tr>
	</table>
	<table id="print" style="width:100%; margin:5px 0;">
      <tbody id="perscroll" style="overflow-y:auto; overflow-x:hidden; width:100%; background-color:#fff; float:left; border: 1px solid #eaeaea;border-radius:5px;margin-bottom:0;">
  <tr class="cart__row cart__header-labels" style="border-bottom: 1px solid #eaeaea; font-weight:bold;">
        <td style="text-align:left !important;">Emërtimi</td>
		<td style="min-width:100px;text-align:center;">Sasia</td>
        <td style="min-width:100px;text-align:center;">Cmimi</td>
		<td style="min-width:100px;text-align:center;">Vlera</td>
        <?php  $result ="SELECT * FROM produkte_te_shitura WHERE fature_id= '$faa[id]' AND tipi IS NULL  ORDER BY id ASC";
			$prod = mysql_query($result);
			$x = 0; $totam=0;$totam2=0; $koha_totale = 0; 
while($row = mysql_fetch_array($prod)){ $skkonto = $row["skonto"];
$produkt_name = mysql_fetch_array(mysql_query("SELECT titulli FROM produkte where id='$row[produkt_id]'"));?>
<tr class="cart__row table__section" style="border-bottom: 1px solid #eaeaea;">
<td style="text-align:left !important;padding-bottom:0;"><?php if($row["produkt_id"] !="0"){ echo $produkt_name['titulli'];}else{echo "Recete";} ?>  
<?php if(!empty($row['shenime'])){ ?><p style="text-align:left;font-size:10px;margin-bottom:0; font-weight:bold;"><?php echo $row['shenime']; ?></p><?php } ?></td>
<td style="text-align:center;"><?php echo $row['sasia']; ?></td>
<td style="text-align:center;"><?php $ppp=$row['cmimi'] / $row['sasia']; echo number_format($ppp,2); ?></td>
<td style="text-align:center;"><?php $pppa=$row['cmimi']; $pppa2= ($row['cmimi'] - ($row['cmimi'] * ($row["skonto"] / 100))); echo number_format($pppa,2); ?></td>
<?php $totam += $pppa; $totam2 += $pppa2;?>
</tr>
<?php } ?>
 </tbody>
    </table> <table style="margin-top:0px; width:100%; border-top:2px solid black;">
<tr  style='border:none;' class="cart__row table__section">	
	<?php if($row["shitur_nga"] == "Web"){ ?><td style="min-width:100px;border: none;">Porosi Online</td><?php }else{ ?><td style="min-width:100px;border: none;"></td><?php } ?>
	<td style="min-width:100px;border: none;"><?php if($skkonto > 0){ echo $skkonto; ?>% Skonto<?php } ?></td><td style="min-width:100px;border: none;"></td>
<td style="min-width:100px;text-align:center;"><?php if($skkonto > 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>
 </tr>
 </table>
	</div>
	 <div style='border:none; width:100%; font-size:10px; font-weight:bold; margin-top:10px'><?php  echo $faa["kontaktet"]; ?></div>	  
	<div class="footer-content" id="footerii" style="display:none;margin-top:50px; text-align:center;">
            <span class="" style='padding-right:15px;'>Adresa: <?php echo $linku["artikulli"]; ?></span></br> 
            <span class="" style='padding-right:15px;'>Mobel <?php echo $linku["titulli"]; ?> <img src="images/media.svg" style="width: 25px;margin-top: -3px;"> / <img src="images/instagram-colourful-icon.png" style="width:20px;"> medical center Dybeli Group</span></br> 
 <span class="" style='padding-right:15px;'> Stomatologji - Dermoestetike - Pediatri - Gjinekologji - Fizioterapi - Laborator Mjekësor - Mjek familje </span> </br> 
            <span class="" style='padding-right:15px;'> www.campusiea.com  -  www.dmc.al</span> 
          </div> 
	<?php  } ?> <style>@media print{#footerii { position: fixed; bottom: 50px; text-align:center; width:100%;} .footer-content,#koka {display:none !important; }  }</style> <?php }elseif($print == 2){ ?>
		<div style="overflow-x:hidden; margin-bottom:10px;">
	<center ><div style="font:bold 20px 'Aleo';">Lista Artikujve</div>
		<span style="font-size:11px;"><?php echo $linku["slide"]; ?><br><br>	
	</span><br>
		
	<span style="font-size:10px;">Printuar më : <?php echo date("d.m.Y H:i:s"); ?></span>
	</center>
	<table id="print" style="width:100%; margin:5px 0;">
	
      <tbody id="perscroll" style="overflow-y:auto; overflow-x:hidden; width:100%; background-color:#fff; float:left; border: 1px solid #eaeaea;border-radius:5px;margin-bottom:0;">
  <tr class="cart__row cart__header-labels" style="border-bottom: 1px solid #eaeaea; font-weight:bold;">
        <td style="text-align:left !important;">Emërtimi</td>
		<td style="min-width:100px;text-align:center;">Sasia</td>
   <?php $array = array(); ?>

<?php  $result ="SELECT produkt_id, SUM(sasia) as sasia FROM produkte_te_shitura WHERE id != '0' ";
			if(!empty($search))
{
 $result .= " AND (id LIKE '%$search%' OR user_id LIKE '%$search%' OR totali LIKE '%$search%' OR skonto LIKE '%$search%' OR kontaktet LIKE '%$search%')";		
}
	if(!empty($doktori))
{ 
 $result .= " AND user_id='$doktori'";	
}
if($fatura_te_turnit !="")
{ 
 $result .= " AND mbyllur='$fatura_te_turnit'";	
}
if($mbyllur_nga !="")
{ 
 $result .= " AND mbyllur_nga='$mbyllur_nga'";	
}
	if(!empty($motorristi))
{ 
 $result .= " AND motorristi='$motorristi'";	
}if($fatura_te !="")
{ 
 $result .= " AND shitur_nga='$fatura_te'";	
}if($skonto_fature !=""){if($skonto_fature =="1"){$result .= " AND skonto !=''";}else{ $result .= " AND skonto =''"; }}
if($katering_dyqan !="")
{ 
 $result .= " AND katering='$katering_dyqan'";	
}if(!empty($dyqani))
{ 
 $result .= " AND dyqan_id='$dyqani'";	
}if($produkte_te !=""){ if($produkte_te =="2"){ $result .= " AND arka='1' AND dorezuar <= '$data_sotme 23:59:59' AND dorezuar >= '$data_sotme 00:00:00'"; }else{ $result .= " AND arka='$produkte_te'";	}}
if(!empty($from))
{
 $result .="AND data >='$from $time'";
}if($metoda_pageses !="")
{ 
 $result .= " AND metoda_pageses='$metoda_pageses'";	
}if($printuara !="")
{ 
 $result .= " AND print='$printuara'";	
}
if(!empty($to))
{
$result .="AND data <='$to $time2'";
}
$result .="group by produkt_id";
			$prod = mysql_query($result);
		 $totam=0;
while($row = mysql_fetch_array($prod)){
$sum = mysql_fetch_array(mysql_query("SELECT  FROM produkte_te_shitura WHERE fature_id= '$faa[id]' AND produkt_id = '$row[produkt_id]'"));
$produkt_name = mysql_fetch_array(mysql_query("SELECT titulli FROM produkte where id='$row[produkt_id]'"));?>
<tr class="cart__row table__section" style="border-bottom: 1px solid #eaeaea;">
<td style="text-align:left !important;padding-bottom:0;"><?php if($row["produkt_id"] !="0"){ echo $produkt_name['titulli'];}else{echo "Recetë";} ?>   
<?php if(!empty($row['shenime'])){ ?><p style="text-align:left;font-size:10px;margin-bottom:0; font-weight:bold;"><?php echo $row['shenime']; ?></p><?php } ?></td>
<td style="text-align:center;"><?php echo $row['sasia']; ?></td>
<?php $totam += $row['sasia']; ?>
</tr>
	<?php  } ?> 
		 </tbody>
    </table>
	</div>
	 <table style="border-top:2px solid black;width:100%; text-align:center;">
<tr  style='border:none;' class="cart__row table__section">	
<td style="border: none;"><?php if($faa["katering"] != 0){ ?>Porosi Online<?php } ?></td>
<td style="text-align:center;"><?php if($row["skonto"] > 0){ echo "<b>".number_format($totam2,2)."</b>"; echo "<span style='margin-left : 10px;color:red; text-decoration: line-through;'><b>".$totam."</b></span>"; }else{ echo "<b>".$totam."</b>"; } ?> </td>
 </tr>
 </table>
	 <div style='border:none; width:100%; font-size:10px; font-weight:bold; margin-top:10px'><?php  echo $faa["kontaktet"]; ?></div>	  
	<div class="footer-content" id="footerii" style="display:none;margin-top:50px; text-align:center;">
            <span class="" style='padding-right:15px;'>Adresa: <?php echo $linku["artikulli"]; ?></span></br> 
            <span class="" style='padding-right:15px;'>Mobel <?php echo $linku["titulli"]; ?> <img src="images/media.svg" style="width: 25px;margin-top: -3px;"> / <img src="images/instagram-colourful-icon.png" style="width:20px;"> medical center Dybeli Group</span></br> 
 <span class="" style='padding-right:15px;'> Stomatologji - Dermoestetike - Pediatri - Gjinekologji - Fizioterapi - Laborator Mjekësor - Mjek familje </span> </br> 
            <span class="" style='padding-right:15px;'> www.campusiea.com  -  www.dmc.al</span> 
          </div> <style>@media print{ #footerii { position: fixed; bottom: 50px; text-align:center; width:100%;} .footer-content,#koka {display:none !important; }  }</style>   <?php  }
		  mysql_query("UPDATE produkte_te_shitura SET mbyllur='1', data_mbylles_se_turnit = '$dt_a', mbyllur_nga = '$_SESSION[userid]'");
	$sql = "UPDATE fatura SET mbyllur='1', data_mbylles_se_turnit = '$dt_a', mbyllur_nga = '$_SESSION[userid]' WHERE id !='0' ";
 	if(!empty($doktori))
{ 
 $sql .= " AND user_id='$doktori'";	
}
if($fatura_te_turnit !="")
{ 
 $sql .= " AND mbyllur='$fatura_te_turnit'";	
}
if(!empty($mbyllur_nga))
{ 
 $sql .= " AND mbyllur_nga='$mbyllur_nga'";	
}
	if(!empty($motorristi))
{ 
 $sql .= " AND motorristi='$motorristi'";	
}if($fatura_te !="")
{ 
 $sql .= " AND shitur_nga='$fatura_te'";	
}
if($katering_dyqan !="")
{ 
 $sql .= " AND katering='$katering_dyqan'";	
}if($skonto_fature !=""){if($skonto_fature =="1"){$sql .= " AND skonto !=''";}else{ $sql .= " AND skonto =''"; }}
	if(!empty($dyqani))
{ 
 $sql .= " AND dyqan_id='$dyqani'";	
}if($produkte_te !=""){ if($produkte_te =="2"){ $sql .= " AND arka='1' AND orari_arkes <= '$data_sotme 23:59:59' AND orari_arkes >= '$data_sotme 00:00:00'"; }else{ $sql .= " AND arka='$produkte_te'";	}}
if($metoda_pageses !=""){ 
 $sql .= " AND metoda_pageses='$metoda_pageses'";	
}if($printuara !="")
{ 
 $sql .= " AND print='$printuara'";	
}
if(!empty($from))
{
$sql .="AND data >='$from $time'";
}
if(!empty($to))
{
$sql .="AND data <='$to $time2'";
}
	mysql_query($sql);
	
	exit();
}
if(isset($_POST["column_name"]) && isset($_POST["id"]))
{
 $id = preg_replace('#[^0-9]#', '',$_POST["id"]);  
 $text = preg_replace('#[^0-9.]#', '',$_POST["text"]); 
echo $column_name = preg_replace('#[^0-9A-Za-z.-_]#', '',$_POST["column_name"]); 
 $sql = mysql_query("UPDATE sales_order SET ".$column_name."='".$text."' WHERE transaction_id='".$id."'"); 
 exit();
}	$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["cmtvsh"])){

$emertimi = strip_tags($_POST["emertimi"]);$njesia_shto = strip_tags($_POST["njesia_shto"]);
	$sasia = preg_replace('#[^0-9]#', '',$_POST["sasia"]);
	$cmtvsh = preg_replace('#[^0-9]#', '',$_POST["cmtvsh"]);
	$tvshja = preg_replace('#[^0-9]#', '',$_POST["tvshja"]);
	$barkodi = preg_replace('#[^0-9]#', '',$_POST["barkodi"]);
	if($_POST["tipi"] == "fature_blerje"){
	mysql_query("INSERT INTO `produkte`(`titulli`, `data`, `cmimi_bleres`, 
	 `njesia`, `sasia`, `sasi_shitur`, `tvsh`, `barkodi`,`produkt_sherbim`) VALUES 
('$emertimi','$dt_a','$cmtvsh','$njesia_shto','$sasia','0','$tvshja','$barkodi','Produkt')"); 
	}else
	{
		
	mysql_query("INSERT INTO `produkte`(`titulli`, `data`, `cmimi_shitjes_shumice`, 
	 `njesia`, `sasia`, `sasi_shitur`, `tvsh`, `barkodi`) VALUES 
('$emertimi','$dt_a','$cmtvsh','$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 =  preg_replace('#[^0-9A-Za-z.]#', '', $_POST['product_code']);

$customer_id = preg_replace('#[^0-9]#', '',$_POST['furnitori']);
$date = date("m/d/y");
if(empty($product_code) && !empty($b))
{
$pro = "SELECT * FROM produkte where id='$b'";
}
elseif(empty($b) && !empty($product_code))	
{
$pro = "SELECT * FROM produkte where barkodi='$product_code'";
}
$prod = mysql_query( $pro);
if($customerrow["id"] !=''){$customerid = $customerrow["id"];}else{$customerid =0;}
if(mysql_num_rows($prod) > 0)
{
$row=mysql_fetch_array($prod);
$product_id=$row['id'];
if($tipi =="fature_blerje"){$asasa=$row['cmimi_bleres']; }else{ $asasa=$row['cmimi_shitjes_shumice']; }  
if($customer_id !="" && $tipi =="fature_shitje")
{
$customer = mysql_fetch_array(mysql_query("SELECT id,skonto FROM klient_furnitor where id='$customer_id'"));
$percent=$customer["skonto"] / 100;
$cmime_shumice = mysql_fetch_array(mysql_query("SELECT cmimi_pa_tvsh FROM produktet_fature_shitje where klient_id='$customer_id' AND produkt_id ='$product_id' order by id desc limit 1"));
if($cmime_shumice["cmimi_pa_tvsh"] !=""){
$asasa = $cmime_shumice["cmimi_pa_tvsh"];
}}
$code=$row['barkodi'];
$name=$row['titulli'];
$njesia=$row['njesia'];
$tvsh=$row['tvsh'];
$vtshjj = ($row['tvsh'] / 100);
//edit qty
 $fffffff=$asasa-($asasa * $percent);
$d=$fffffff*$c + ($fffffff * $vtshjj);
// query
$sql2 = "SELECT invoice FROM sales_order WHERE invoice='$_SESSION[userid]' 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' WHERE invoice='$_SESSION[userid]' AND product='$product_id'";
$asdasd3 = mysql_query( $sql3);
}
else
{
$sql4 = "INSERT INTO sales_order(invoice,product,qty,amount,name,price,product_code,date,user_id, discount, njesia, tvsh, tipi) VALUES 
('$_SESSION[userid]','$product_id','$c','$d','$name','$fffffff','$code','$date','$customerid','-$customerrow[skonto]%','$njesia','$tvsh','$tipi')";
$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 style="background-color:red;color:white;padding: 4px;border-radius: 5px;text-align: center;">
<h5 style="font-weight:bold;">Kujdes ! sasia e <?php echo $row['titulli']; ?> është nën limitin e caktuar</h5>
</div> <?php } } ?>
<style> td{ padding: 10px 15px;}th {
padding: 10px 15px;    font-size: 14px; font-weight:normal; }.nav-tabs .nav-link{border: 1px solid rgb(222, 222, 222);}.nav-tabs .nav-link:hover {
    border-color: #ffffff #ffffff #ddd;
}
[contentEditable=true]:empty:not(:focus):before{ content:attr(data-text) }

</style>
    <table id="print" style="width:100%; margin-bottom:0;">
      <thead class="cart__row cart__header-labels" style="border: 1px solid #e5e5e5;font-size:11px; background-color:#fafafa;">
		<th style="border: 1px solid #e5e5e5;text-align:center;font-weight:bold;" class="text-center">Nr.</th>
        <th style="border: 1px solid #e5e5e5;text-align:center;font-weight:bold;" class="text-center">Emërtimi</th>
		<th style="border: 1px solid #e5e5e5;text-align:center;font-weight:bold;" class="text-center">Njësia</th>
		<th style="border: 1px solid #e5e5e5;text-align:center;font-weight:bold;" class="text-center">Sasia</th>
        <th style="border: 1px solid #e5e5e5;text-align:center;font-weight:bold;" class="text-center">Cmimi pa TVSH</th>	
        <th style='min-width:150px; text-align:center;font-weight:bold;' class="text-center">Cmimi me TVSH</th>
		<th style="border: 1px solid #e5e5e5;text-align:center;font-weight:bold;" class="text-center">Vlera pa TVSH</th>
		<th style="border: 1px solid #e5e5e5;text-align:center;font-weight:bold;" class="text-center">Vlera e TVSH</th>
		<th style="border: 1px solid #e5e5e5;text-align:center;font-weight:bold;" class="text-center">Vlera me TVSH</th>
		 <?php if(!empty($customer_id) && mysql_num_rows($customer) > 0){ ?> <th style="border: 1px solid #e5e5e5;text-align:center;font-weight:bold;" class="text-center">Discount</th><?php  } ?>
      </thead>
      <tbody>
        <?php 
		$result ="SELECT * FROM sales_order WHERE invoice= '$_SESSION[userid]' AND tipi = '$tipi'";
			$prod = mysql_query($result);
			$totam=0; $x = 1;
while($row = mysql_fetch_array($prod)){
	$vasdstshjj = ($row['tvsh'] / 100);
	$hiq_tvsh = 1 + ($row['tvsh'] / 100);	?>
        <tr class="cart__row table__section" style="border: 1px solid #e5e5e5;">
		 <td style="border: 1px solid #e5e5e5;" data-label="Product"> 
<button  name="delete_btn" data-id4="<?php echo $row["transaction_id"]; ?>" id="delete" type='button' style="float:left;background-color:red;border-radius: 10% 10% 60% 10%;    padding: 0px 5px;color:white;font-size: 10px;margin-left: -15px;margin-top: -10px;border: 0;cursor: pointer;"><small><i class="icon-close2" style="margin-left: -2px;"></i></small></button> 
          
         
            <?php echo $x; ?></td>
          <td style="border: 1px solid #e5e5e5;" class="name"><?php echo $row['name']; ?></td>
		  <td style="border: 1px solid #e5e5e5;" data-id5=<?php echo $row["transaction_id"]; ?> class="njesia" <?php if($_SESSION["category"] != "Magazinier"){ ?>contenteditable<?php } ?>><?php echo $row['njesia']; ?></td>
<td style="border: 1px solid #e5e5e5;padding:0;" data-id1=<?php echo $row["transaction_id"]; ?>  class="qty" contenteditable> <?php echo $row['qty']; ?></td>
          <td style="border: 1px solid #e5e5e5;" data-id2=<?php echo $row["transaction_id"]; ?>  class="price_pa_tvsh"><?php $ppp=$row['price'] / $hiq_tvsh; echo number_format($ppp,2); ?></td>
		  <td style="border: 1px solid #e5e5e5;" data-id2=<?php echo $row["transaction_id"]; ?>  class="price" contenteditable><?php $ppp=$row['price']; echo number_format($ppp,2); ?></td>
		  <td style="border: 1px solid #e5e5e5;" class="text-center price-row" data-label="Price">
            <span>
             	<?php
				
			$pppa=($row['price'] * $row['qty']) / $hiq_tvsh;
			echo number_format($pppa,2);
			?>
            </span>
          </td>
		   <td style="border: 1px solid #e5e5e5;" data-id3=<?php echo $row["transaction_id"]; ?> 
		   class="tvsh"><span><?php $vl_tvsh = $pppa * $vasdstshjj; echo number_format($vl_tvsh,2); ?></span></td>
		      <td style="border: 1px solid #e5e5e5;" class="text-center price-row" data-label="Price">
            <span>
             	<?php
			$ppp2=$pppa + ($pppa * $vasdstshjj);
			echo number_format($ppp2,2);
			?>
            </span>
          </td>
		   <?php if(!empty($customer) && mysql_num_rows($customerprod) > 0){ ?>  
		   <td style="border: 1px solid #e5e5e5;" class="text-center" data-label="Quantity">
           -<?php echo $customerrow["skonto"]; ?> %
          </td>
		   <?php } ?>    
            <?php
			
			$totam += $ppp2;
			?>
           
 
        </tr>
        <?php $x++; } ?>
		<tr id="shto_produkt_fshi"> 
		<td style="border: 1px solid #e5e5e5; font-size:11px; color:#d4d4d4;" id="barkodi" contenteditable="true" data-text="Barkodi"></td>
		<td style="border: 1px solid #e5e5e5; font-size:11px; color:#d4d4d4;" id="emertimi" contenteditable="true" class="text-center" data-text="Emërtimi"></td>
		<td style="border: 1px solid #e5e5e5; font-size:11px; color:#d4d4d4;" id="njesia_shto" contenteditable="true"  class="text-center" data-text="Njësia"></td>
		<td style="border: 1px solid #e5e5e5; font-size:11px; color:#d4d4d4;" id="sasia" contenteditable="true"  class="text-center" data-text="Sasia"></td>
        <td style="border: 1px solid #e5e5e5;" id="cpatvsh" class="text-center"></td>
		<td style="border: 1px solid #e5e5e5; font-size:11px; color:#d4d4d4;" id="cmtvsh" contenteditable="true" class="text-center" data-text="Cmimi me TVSH"></td>
		<td style="border: 1px solid #e5e5e5;" id="vptvsh" class="text-center"></td>
		<td style="border: 1px solid #e5e5e5; font-size:11px; color:#d4d4d4;" id="tvshja" contenteditable="true"  class="text-center" data-text="TVSH"></td>
		<td style="border: 1px solid #e5e5e5;" id="vmtvsh" class="text-center"><button type="button" name="add" class="btn btn-success btn-block" style="background: #37BC9B;padding: 0;margin: 0 auto;width: 20px;" id="add">+</button></td>
		</tr>
	   <tr  style='border:none;' class="cart__row table__section">	
			<td style="border: none;"> </td>
			<td style="border: none;">  </td>
			<td style="border: none;">  </td><td style="border: none;">  </td>
			<td style="border: none;">  </td><td style="border: none;">  </td><td style="border: none;">  </td><td style="border: none;">  </td>
			<?php if(!empty($customer_id) && mysql_num_rows($customer) > 0){ ?> 	<td style="border: none;">  </td><?php  } ?>
			<td style="border: 1px solid #e5e5e5; text-align:center;"><span class="h4 cart__subtotal"> <?php echo number_format($totam,2); ?></span></td>
			  </tr>
      </tbody>
    </table>

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