1old-ajax-edit.php

<?php
    include('database.php');
    error_reporting(0);
    $status = $_POST['status'];
    // echo $status;

if ($status == 'edit-pagination') {
        $tableName = 'tbl_pagination_count';
        if ($_POST['defaultSet'] == 'YES') {
            // Set all other "YES" values to "NO"
            mysqli_query($con, "UPDATE ".$tableName." SET `defaultSet` = 'NO' WHERE `defaultSet` = 'YES'");
        }
        // Set the last updated record to "YES"
        mysqli_query($con, "UPDATE ".$tableName." SET `defaultSet` = 'YES' WHERE id = ".$_POST['id']);
        $updateArray = updateData($tableName, $_POST);
        echo $updateStatus = $updateArray[0];
    }

// if($status == 'edit-testimonial') {
    //     $tableName = 'tbl_testimonial';
    //     $folderName = 'testimonialImage';
    //     $fieldId = 'testId';
    //     $fieldId1 = 'image';
    //         $updateArray = updateData($tableName, $_POST);
    //         $imageArray = uploadImageDoc($tableName, $folderName, 'image', $_POST['baseUrl'], $_POST['id'], $fieldId,$fieldId1);
    //    echo $uploadStatus = $imageArray[0];
    // }

if($status == 'edit-addUser') {
        $tableName = 'tbl_user';
        $fieldId = 'userId';
            $updateArray = updateData($tableName, $_POST);
       echo $uploadStatus = $updateArray;
    }

if($status == 'edit-ferm') {
        $tableName = 'tbl_ferm';
        $fieldId = 'fermId';
            $updateArray = updateData($tableName, $_POST);
       echo $uploadStatus = $updateArray;
    }

if($status == 'edit-buy') {
        $tableName = 'tbl_buy';
        $fieldId = 'buyId';
            $updateArray = updateData($tableName, $_POST);
       echo $uploadStatus = $updateArray;
    }

if($status == 'edit-sell') {
        $tableName = 'tbl_sell';
        $fieldId = 'sellId';
            $updateArray = updateData($tableName, $_POST);
            // $query = mysqli_query("UPDATE tbl_sell SET dispatchedOrNot = '1' WHERE sellId = $_POST['id']");
       echo $uploadStatus = $updateArray;
    }

if($status == 'edit-mill') {
        $tableName = 'tbl_mill';
        $fieldId = 'millId';
            $updateArray = updateData($tableName, $_POST);
       echo $uploadStatus = $updateArray;
    }
    if($status == 'edit-customer') {
        $tableName = 'tbl_customer';
        $fieldId = 'customerId';
            $updateArray = updateData($tableName, $_POST);
       echo $uploadStatus = $updateArray;
    }
  
   if($status == 'delete-addUser') {
        if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['id'])) {
            $id = $_POST['id'];

// Update the database to mark the entry as deleted
            $updateQuery = "UPDATE `tbl_user` SET `deleteStatus` = '1' WHERE `userId` = '$id'";
            $result = mysqli_query($con, $updateQuery);

if ($result) {
                echo '0';
            } else {
                echo '1';
            }
        } else {
            echo 'Invalid request';
        }
    }

if($status == 'delete-ferm') {
        if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['id'])) {
            $id = $_POST['id'];

// Update the database to mark the entry as deleted
            $updateQuery = "UPDATE `tbl_ferm` SET `deleteStatus` = '1' WHERE `fermId` = '$id'";
            $result = mysqli_query($con, $updateQuery);

if ($result) {
                echo '0';
            } else {
                echo '1';
            }
        } else {
            echo 'Invalid request';
        }
    }

if ($status == 'delete-dispatch') {
        if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['id'])) {
            $id = mysqli_real_escape_string($con, $_POST['id']);

$query11 = mysqli_query($con, "SELECT weight_kg AS totalWeight, weight AS sWeight FROM tbl_sell WHERE deleteStatus = 0 AND `sellId` = '$id'");
            $row11 = mysqli_fetch_array($query11);
            $totalWeight = $row11['totalWeight'];
            $sWeight = $row11['sWeight'];

$query77 = mysqli_query($con, "SELECT * FROM `tbl_dispache` ORDER BY `dispach_id` DESC LIMIT 1");
            $row77 = mysqli_fetch_array($query77);
            $latestBuyId = $row77['buyId'];
            $latestsellId = $row77['sellId'];

$query22 = mysqli_query($con, "SELECT weight_kg AS totalWeight , weight AS tWeight FROM tbl_buy WHERE buyId = '$latestBuyId'");
            $row22 = mysqli_fetch_array($query22);
            $totalWeight22 = $row22['totalWeight'];
            $tWeight22 = $row22['tWeight'];

$query_dis = mysqli_query($con, "SELECT dispache_weight_kg AS totaldis FROM tbl_dispache WHERE deleteStatus = 0 AND `sellId` = '$id'");
            $row_dis = mysqli_fetch_array($query_dis);
            $totaldis = $row_dis['totaldis'];

$totalstock = $totalWeight - $totaldis;
            $totalstock22 = $totalWeight22 - $totaldis;

// $totalstock = $totalWeight - $totaldis;

$tonstock = $totalstock / 1000;
            $tonstock22 = $totalstock22 / 1000;

$finalweight = $_POST['finalWeight'];
            if ($totaldis > $totalWeight22) {
                $abc = $totaldis - $totalWeight22;
                $weight11 = $tWeight22 + $abc;

$totalstock2233 = $weight11 - $totaldis;
                $tonstock2233 = $totalstock2233 / 1000;

$final = mysqli_query($con, "UPDATE tbl_buy SET weight = '$weight11', `weight_kg` = '$totalstock2233', `weight_ton` = '$tonstock2233' WHERE `buyId` = '$latestBuyId'");
                $final1 = mysqli_query($con,"UPDATE `tbl_sell` SET `dispachedOrNot` = '1',`weight` = '$weight11', `weight_kg` = '$totalstock2233', `weight_ton` = '$tonstock2233' WHERE `sellId` = '$latestsellId'");

if ($final && $final1) {
                    echo '0'; // Success
                } else {
                    echo '1'; // Failure
                }
            }
            else if($totaldis > $totalWeight){
                $xyz = $totaldis - $totalWeight;
                $weight22 = $sWeight + $xyz;

$totalstock23 = $weight22 - $totaldis;
                $tonstock23 = $totalstock23 / 1000;

$abc = $totaldis - $totalWeight22;
                $weight11 = $tWeight22 + $abc;

$totalstock2233 = $tWeight22 - $weight22;
                $tonstock2233 = $totalstock2233 / 1000;

$final = mysqli_query($con, "UPDATE tbl_buy SET `weight` = '$tWeight22', `weight_kg` = '$totalstock2233', `weight_ton` = '$tonstock2233' WHERE `buyId` = '$latestBuyId'");

$final1 = mysqli_query($con,"UPDATE `tbl_sell` SET `dispachedOrNot` = '1',`weight` = '$weight22', `weight_kg` = '$totalstock23', `weight_ton` = '$tonstock23' WHERE `sellId` = '$latestsellId'");

if ($final1 && $final) {
                    echo '0'; // Success
                } else {
                    echo '1'; // Failure
                }

} 
            else {
                $updateQuery2 = "UPDATE `tbl_buy` SET `weight_kg` = '$totalstock22', `weight_ton` = '$tonstock22' WHERE `buyId` = '$latestBuyId'";
                $result2 = mysqli_query($con, $updateQuery2);

$updateQuery1 = "UPDATE `tbl_sell` SET `dispachedOrNot` = '1', `weight_kg` = '$totalstock', `weight_ton` = '$tonstock' WHERE `sellId` = '$id'";
                $result1 = mysqli_query($con, $updateQuery1);

if ($result1 && $result2) {
                    echo '0'; // Success
                } else {
                    echo '1'; // Failure
                }
            }
        } else {
            echo 'Invalid request';
        }
    }

if($status == 'delete-buy') {
        if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['id'])) {
            $id = $_POST['id'];

// Update the database to mark the entry as deleted
            $updateQuery = "UPDATE `tbl_buy` SET `deleteStatus` = '1' WHERE `buyId` = '$id'";
            $result = mysqli_query($con, $updateQuery);

if ($result) {
                echo '0';
            } else {
                echo '1';
            }
        } else {
            echo 'Invalid request';
        }
    }

if($status == 'delete-sell') {
        if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['id'])) {
            $id = $_POST['id'];

// Update the database to mark the entry as deleted
            $updateQuery = "UPDATE `tbl_sell` SET `deleteStatus` = '1' WHERE `sellId` = '$id'";
            $result = mysqli_query($con, $updateQuery);

if ($result) {
                echo '0';
            } else {
                echo '1';
            }
        } else {
            echo 'Invalid request';
        }
    }

if($status == 'delete-mill') {
        if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['id'])) {
            $id = $_POST['id'];

// Update the database to mark the entry as deleted
            $updateQuery = "UPDATE `tbl_mill` SET `deleteStatus` = '1' WHERE `millId` = '$id'";
            $result = mysqli_query($con, $updateQuery);

if ($result) {
                echo '0';
            } else {
                echo '1';
            }
        } else {
            echo 'Invalid request';
        }
    }

if($status == 'delete-customer') {
        if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['id'])) {
            $id = $_POST['id'];

// Update the database to mark the entry as deleted
            $updateQuery = "UPDATE `tbl_customer` SET `deleteStatus` = '1' WHERE `customerId` = '$id'";
            $result = mysqli_query($con, $updateQuery);

if ($result) {
                echo '0';
            } else {
                echo '1';
            }
        } else {
            echo 'Invalid request';
        }
    }
?>

docroot: /home/u856302147/domains/creativegardendesign.in/public_html

curdir: /home/u856302147/domains/vparking.live/public_html/doctor/Config

	.	4096
	..	4096
X	Milestone Details	2225
X	ajax-add.php	68152
X	ajax-add.php-bkp	51355
X	ajax-edit.php	22262
X	ajax-get.php	280611
X	ajax-get.php-bkp	254704
X	ajax-remove.php	499
X	checkURL.php	553
X	colors.php	947
X	demo.php	1206
X	old-ajax-edit.php	10209
X	print.html	1821
X	reports-get.php	36886
X	test.php	39690
	upload	4096