1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / sathmcmy / public_html / admin /
Filename : load_more_pending_orders_ajax.php
back
<?php 

    ini_set( 'session.cookie_httponly', 1 ); // added part
    ini_set( 'session.use_strict_mode', 1 ); // added part

    // echo $_POST['limit'];
    // echo "\n";
    // echo $_POST['offset'];
    // exit;
    // echo "The limit is". $_POST['limit'];
    // exit;
    // echo $_POST['offset'];
    // exit;
    session_start();
    // echo $_POST['last_prod_id'];
    // exit;

    if(!isset($_POST)) {
        exit;
    }

    if($_POST['uniq_token'] != $_SESSION['token_load_more_orders']) {
        exit;
    }

    // To be removed
    // if(!preg_match('/^[0-9]+$/', $_POST['last_prod_id']))  {
    //     exit;
    // }

    if(!preg_match('/^[0-9]+$/', $_POST['limit']))  {
        exit;
    }

    if(!preg_match('/^[0-9]+$/', $_POST['offset']))  {
        exit;
    }

    if(!preg_match('/^[0-9]+$/', $_POST['counter']))  {
        exit;
    } 

    $counter = $_POST['counter'];
    // $counter=1;



    include_once "../lib/Database.php";
    include_once "../classes/Cart.php";

    $db   = new Database();
    $ct   = new Cart();

    // To be removed
    // $last_product_id = htmlspecialchars($_POST['last_prod_id']);
    // $last_product_id = mysqli_real_escape_string($db->link, $last_product_id);

    $limit_value = htmlspecialchars($_POST['limit']);
    $limit_value = mysqli_real_escape_string($db->link, $limit_value);


    $offset = htmlspecialchars($_POST['offset']);
    $offset = mysqli_real_escape_string($db->link, $offset);

    // token_processing_order
    function token_load_more_orders() {
        $token= bin2hex(random_bytes(32));
        $_SESSION['token_load_more_orders'] = $token;
        return $token;
    }

?>

<?php 

$getOrders= $ct->getMoreOrdersAjax($limit_value, $offset);


// $orders= $getOrders->fetch_assoc();

// echo "<pre>";
//     var_dump($getOrders);
// echo "</pre>";
// exit;
// $counter= $counter;
if(!$getOrders) {
    exit;
}
while($row= $getOrders->fetch_assoc())  {
    // echo $row['order_id'] . "<Br />". $row['cmrId'];
?>

<section class="accordion">
    <article class="accordion__item" data-accordion-item>
        <!-- <button class="accordion__button"></button> -->
        <h3 class="accordion__item-header" style='cursor: pointer;' data-accordion-button><?php echo "<span style='color: dodgerblue;'><strong>[$counter.]</strong> ".$row['name'] . " || Address: ". $row['address']. " || City: ". $row['city'] . " || Phone: ". $row['phone']. " || Email: ". $row['email'] . " || Zip: ". $row['zip'] . " || Country: ". $row['country'] ." </span>"; ?><span class="accordion__item-header-icon" data-accordion-button-icon></span></h3>
        <div class="" data-accordion-content>
        <?php 
            // $sql= "SELECT * FROM tbl_order WHERE order_id=". $row['order_id'] . " AND cmrId=". $row['cmrId'];
            $allOrders= $ct->getAllOrders($row['order_id'], $row['cmrId']);
            // echo $sql;
            // $all_o= $allOrders->fetch_assoc();
            // var_dump($allOrders);exit;

            $inner_counter= 1;
            while($r= $allOrders->fetch_assoc()) {
                // echo $r['orderId'];
        ?>
        <p>
        <?php  
                if($r['status'] == 2) {
                    echo "<span style='background: teal; color: #fff; padding: .3rem .5rem;'>Processing</span>";
                }
        ?>
            
            <input type='checkbox' style="font-size:" class='check_boxes' value='<?php echo $r["orderId"]; ?>'>
            <?php echo "[$inner_counter] Product Name: ". $r['productName']; ?> || 
            Image: <img style='width: 150px; height: 150px;' src="<?php echo $r['image']; ?>" alt=""> || 
            <span>Ordered on: <?php echo $r['order_date']; ?></span> || <span>Unit Price: <?php echo $r['price']; ?> || Quantity: <?php echo $r['quantity']; ?> || Total Amount: Rs. <?php echo $r['price']* $r['quantity'] . ".00"; ?></span>
            <?php 
                if($r['status'] != 2):
            ?>
            <a onclick="return confirm('Are you sure?');" style='color:#fcba03;' href="?orderId=<?php echo $r['id']; ?>&makeProcessing=<?php echo $r['productId']; ?>&customer_id=<?php echo $r['cmrId']; ?>&order_random_id=<?php echo $r['orderId']; ?>">Make Processing State</a>
                <?php endif; ?>
            <?php 
                if($r['status'] != 1):
            ?>
            <a onclick="return confirm('Are you sure?');" style='color: green;' href="?orderId=<?php echo $r['id']; ?>&makeDelivered=<?php echo $r['productId']; ?>&customer_id=<?php echo $r['cmrId']; ?>&order_random_id=<?php echo $r['orderId']; ?>">Make Delivered State</a>
                <?php endif; ?>
            <!-- <a onclick="//return makeProcessing(orderId=<?php // echo $r['id']; ?>, makeProcessing=<?php // echo $r['productId']; ?>, customer_id=<?php // echo $r['cmrId']; ?>, order_random_id='<?php // echo $r['orderId']; ?>')" style='color:#fcba03;' href="#">Make Processing State</a> -->
        </p>
        <?php 
                $inner_counter++;
                
            } 
        ?>
        </div>
    </article>
</section>
<?php 
    $counter++;
    $last_p_id= $row['id'];
}

?>
<input id='make_pending_order_token' type="hidden" value="<?php echo token_load_more_orders(); ?>" >
<!-- <input type="hidden" id="last_prod_id" value="<?php // echo $last_p_id; ?>"> -->