File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/BodyCode/login/php_files/savesales.php

<?php

error_reporting(0);
ini_set('display_errors', '0');
include_once("session.php");

$data = date("Y-m-d H:s:i");
if($_POST['delete_id'] != ""){
$delete_id =  preg_replace('#[^0-9]#', '', $_POST['delete_id']);
$sql2 = $session->runQuery("DELETE FROM sales_order where biznes_id=:biznes_id AND user_id=:user_id AND id =:id");
$sql2->execute(array(":biznes_id"=>$biznes_id, ":user_id"=>$user_id, ":id"=>$delete_id));
exit();
}
$product_code =  preg_replace('#[^0-9A-Za-z.-]#', '', $_POST['product_code']);
$furnitori =  preg_replace('#[^0-9]#', '', $_POST['furnitori']);
$tipi =  preg_replace('#[^0-9A-Za-z.]#', '', $_POST['tipi']);
if($product_code != ""){
$stmt = $session->runQuery("SELECT * FROM products where biznes_id =:biznes_id AND barcode=:barcode");
$stmt->execute(array(":biznes_id"=>$biznes_id, ":barcode"=>$product_code));
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if($row["id"] != ""){
$product_id = $row['id'];
$emri = $row['name'];
$cmimi = $row['price'];

$countQuery = $session->runQuery("SELECT COUNT(id) as idd FROM sales_order WHERE user_id=:user_id AND product_id=:product_id AND klienti=:klienti AND tipi=:tipi AND biznes_id=:biznes_id AND dege_id=:dege_id");
$countQuery->execute(array(":biznes_id"=>$biznes_id, ":user_id" => $user_id, ":product_id" => $product_id, ":klienti" => $furnitori, ":tipi" => $tipi,":biznes_id" => $biznes_id, ":dege_id" => $user_dege_id));
$rowCount = $countQuery->fetch(PDO::FETCH_ASSOC)['idd'];
if($rowCount > 0){
$insertQuery = $session->runQuery("UPDATE sales_order SET sasia = sasia + 1 WHERE user_id=:user_id AND product_id=:product_id AND klienti=:klienti AND tipi=:tipi AND biznes_id=:biznes_id AND dege_id=:dege_id");
$insertQuery->execute(array(":user_id" => $user_id, ":product_id" => $product_id, ":klienti" => $furnitori, ":tipi" => $tipi,":biznes_id" => $biznes_id, ":dege_id" => $user_dege_id));
 }else{
$insertQuery = $session->runQuery("INSERT INTO sales_order (user_id, product_id, klienti, tipi, biznes_id, dege_id, sasia, totali, cmimi, name) VALUES (:user_id, :product_id, :klienti, :tipi, :biznes_id, :dege_id, :sasia, :totali, :cmimi, :name)");
$insertQuery->execute(array(":user_id" => $user_id, ":product_id" => $product_id, ":klienti" => $furnitori, ":tipi" => $tipi,":biznes_id" => $biznes_id, ":dege_id" => $user_dege_id, ":sasia" => "1", ":totali" => $cmimi, ":cmimi" => $cmimi, ":name" => $emri));
 }
} else {
echo '<div style="background-color:red;color:white;padding: 4px;border-radius: 16px;text-align: center;margin-bottom:10px;">
<h5 style="font-weight:bold;">Kujdes! Kjo pako nuk ekziston ne sistem</h5>
</div> ';
}
}
?>

<?php
$x = 1;
$stmt = $session->runQuery("SELECT id,name, sasia, cmimi, totali FROM sales_order where user_id=:user_id AND biznes_id=:biznes_id AND dege_id=:dege_id AND klienti=:klienti AND tipi=:tipi ORDER BY id DESC");
$stmt->execute(array(":user_id"=>$user_id, ":biznes_id"=>$biznes_id, ":dege_id"=>$user_dege_id, ":klienti"=>$furnitori, ":tipi"=>$tipi));
$x = $stmt->rowCount();
$totrows = $x;
$totali = 0;
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){ 
$totali += $row['totali'];
?>
        <tr class="cart__row table__section" style="border: 1px solid #e5e5e5;">
		 <td style="border: 1px solid #e5e5e5;text-align:center;" data-label="Product"> 
<button onclick="delete_id('<?php echo $row['id']; ?>')" 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>X</small></button><span><?php echo $x; ?></span></td>
<td style="border: 1px solid #e5e5e5;text-align:center;"><?php echo $row['name']; ?></td>
<td style="border: 1px solid #e5e5e5;text-align:center;"><?php echo $row['sasia']; ?></td>
<td style="border: 1px solid #e5e5e5;text-align:center;"> <?php echo number_format($row['cmimi']); ?></td>
<td style="border: 1px solid #e5e5e5;text-align:center;"> <?php echo number_format($row['totali']); ?></td>
        </tr>
        <?php $x--; } ?>
<tr style="border: 0;">
<td style="border: 0;"></td>
<td style="border: 0;"></td>
<td style="border: 0;"></td>
<td style="border: 0;"></td>
<td style="border: 1px solid #e5e5e5;text-align:center;"><b><?php echo number_format($totali); ?></b></td>
        </tr>
      </tbody>
    </table>

<input type="hidden" value="<?php echo $totali; ?>" name="totali">

Batal

⬅ Naik ke login 11 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘class.functions.php	php	13.1 KB	2023-06-12 02:14	✏️ Edit 👁️ View
🐘class.user.php	php	15.5 KB	2023-01-24 09:17	✏️ Edit 👁️ View
🐘image_resize.php	php	1.5 KB	2023-01-24 08:05	✏️ Edit 👁️ View
🐘lidhja_me_db.php	php	1.9 KB	2023-05-21 16:16	✏️ Edit 👁️ View
🐘lidhja_me_db_mysqli.php	php	291 B	2023-03-10 18:26	✏️ Edit 👁️ View
🐘model_posi.php	php	16.6 KB	2023-06-12 06:59	✏️ Edit 👁️ View
📄model_posi.php$session	php$session	6 B	2023-06-06 23:40	✏️ Edit 👁️ View
🐘pagination.class.php	php	2.8 KB	2023-01-24 17:39	✏️ Edit 👁️ View
🐘savesales.php	php	5.3 KB	2023-06-03 01:31	✏️ Edit 👁️ View
🐘session.php	php	2.4 KB	2023-06-12 06:15	✏️ Edit 👁️ View
🐘status.php	php	1 KB	2023-06-07 21:32	✏️ Edit 👁️ View