    <div class="row">
        <div class="col-12">
            <pre class="with-hljs"><code class="lang-php">&lt;?php
include(&quot;db/cn.php&quot;);

if(isset($_SESSION[&#039;user_name&#039;]) &amp;&amp; isset($_SESSION[&#039;user_role&#039;]) &amp;&amp; isset($_SESSION[&#039;outlet_name&#039;])
 &amp;&amp; isset($_SESSION[&#039;outlet_address&#039;])) {
    $userName = $_SESSION[&#039;user_name&#039;];
    $userRole = $_SESSION[&#039;user_role&#039;];
	$outlet_address = $_SESSION[&#039;outlet_address&#039;];
	$outlet_name = $_SESSION[&#039;outlet_name&#039;];
   
// Check connection
if ($connection-&gt;connect_error) {
    die(&quot;Connection failed: &quot; . $connection-&gt;connect_error);
}

// Initialize a flag to track successful submission
$success = false;

// Check if data is sent via POST method
if ($_SERVER[&quot;REQUEST_METHOD&quot;] == &quot;POST&quot; &amp;&amp; isset($_POST[&#039;customer&#039;]) 
&amp;&amp; isset($_POST[&#039;phone&#039;]) &amp;&amp; isset($_POST[&#039;sale_by&#039;]) &amp;&amp; isset($_POST[&#039;paid_by&#039;])
 &amp;&amp; isset($_POST[&#039;product_id&#039;]) &amp;&amp; isset($_POST[&#039;product_name&#039;]) &amp;&amp; isset($_POST[&#039;discount_amount&#039;]) 
 &amp;&amp; isset($_POST[&#039;product_price&#039;]) &amp;&amp; isset($_POST[&#039;product_quantity&#039;])) {
    // Retrieve customer details
    $customer = $_POST[&#039;customer&#039;];
    $phone = $_POST[&#039;phone&#039;];
    $sale_by = $_POST[&#039;sale_by&#039;];
    $paid_by = $_POST[&#039;paid_by&#039;];
	$discount = $_POST[&#039;discount_amount&#039;];
    
	$date_time = date(&quot;Y-m-d&quot;);
	$orderNumber = uniqid(&#039;ORDER&#039;);
	
// Insert data into cdetail table
$sql_cdetail = &quot;INSERT INTO cdetail (customer_name, phone_number, sale_by, outlet_name, outlet_address, paid_by, order_id) 
				VALUES (&#039;$customer&#039;, &#039;$phone&#039;, &#039;$sale_by&#039;, &#039;$outlet_name&#039;, &#039;$outlet_address&#039;, &#039;$paid_by&#039;, &#039;$orderNumber&#039;)&quot;;
					
	if ($connection-&gt;query($sql_cdetail) === TRUE) {
		$success = true;
	}

    // Retrieve items table data
    $items = array(); // Initialize an empty array for items
    
    // Loop through each item
    for ($i = 0; $i &lt; count($_POST[&#039;product_id&#039;]); $i++) {
        $item = array(
            &#039;id&#039; =&gt; $_POST[&#039;product_id&#039;][$i],
            &#039;name&#039; =&gt; $_POST[&#039;product_name&#039;][$i],
            &#039;price&#039; =&gt; $_POST[&#039;product_price&#039;][$i],
            &#039;quantity&#039; =&gt; $_POST[&#039;product_quantity&#039;][$i],
            &#039;total&#039; =&gt; $_POST[&#039;product_price&#039;][$i] * $_POST[&#039;product_quantity&#039;][$i] // Calculate total price
        );
        $items[] = $item; // Add item to the items array
        
        // Insert item details into pay_hold table
        $sql_pay_hold = &quot;INSERT INTO pay_hold (customer_name, phone_number, sale_by, paid_by, product_name, product_id, product_price, product_quantity, product_total, tax_amount, discount_amount, total_amount, order_id, outlet_name, login_user, user_role, outlet_address, date_time)
        VALUES (&#039;$customer&#039;, &#039;$phone&#039;, &#039;$userName&#039;, &#039;$paid_by&#039;, &#039;{$item[&#039;name&#039;]}&#039;, &#039;{$item[&#039;id&#039;]}&#039;, &#039;{$item[&#039;price&#039;]}&#039;, &#039;{$item[&#039;quantity&#039;]}&#039;, &#039;{$item[&#039;total&#039;]}&#039;, &#039;0&#039; ,&#039;$discount&#039;, &#039;0&#039;, &#039;$orderNumber&#039;, &#039;$outlet_name&#039;, &#039;$userName&#039;, &#039;$userRole&#039;, &#039;$outlet_address&#039;, &#039;$date_time&#039;)&quot;;

        // Execute the query
        if ($connection-&gt;query($sql_pay_hold) !== TRUE) {
            $success = false;
        }
    }
}

// Close connection
//$connection-&gt;close();
if ($success) {
    header(&quot;Location: pos.php&quot;);
    exit; // Make sure to exit after redirection to prevent further execution
}

?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
    &lt;meta charset=&quot;UTF-8&quot;&gt;
    &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1.0&quot;&gt;
    &lt;title&gt;Hold Transaction Details&lt;/title&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;css/custom_css.css&quot;&gt;
    &lt;link href=&quot;https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css&quot; rel=&quot;stylesheet&quot;&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css&quot;&gt;
&lt;/head&gt;
&lt;body&gt;

&lt;div class=&quot;container&quot;&gt;
    &lt;h2&gt;Hold Transaction Details&lt;/h2&gt;
    &lt;form id=&quot;holdForm&quot; action=&quot;hold_pay.php&quot; method=&quot;post&quot;&gt; &lt;!-- Add an id to the form --&gt;
        &lt;h3&gt;Customer Details:&lt;/h3&gt;
        &lt;p&gt;&lt;strong&gt;Customer Name:&lt;/strong&gt; &lt;?php echo $customer; ?&gt;&lt;/p&gt;
        &lt;p&gt;&lt;strong&gt;Phone:&lt;/strong&gt; &lt;?php echo $phone; ?&gt;&lt;/p&gt;
        &lt;p&gt;&lt;strong&gt;Sale By:&lt;/strong&gt; &lt;?php echo $sale_by; ?&gt;&lt;/p&gt;
        &lt;p&gt;&lt;strong&gt;Paid By:&lt;/strong&gt; &lt;?php echo $paid_by; ?&gt;&lt;/p&gt;

        &lt;h3&gt;Items:&lt;/h3&gt;
        &lt;table class=&quot;table&quot;&gt;
            &lt;thead&gt;
                &lt;tr&gt;
                    &lt;th&gt;ID&lt;/th&gt;
                    &lt;th&gt;Name&lt;/th&gt;
                    &lt;th&gt;Price&lt;/th&gt;
                    &lt;th&gt;Quantity&lt;/th&gt;
                    &lt;th&gt;Total&lt;/th&gt;
                &lt;/tr&gt;
            &lt;/thead&gt;
            &lt;tbody&gt;
                &lt;?php foreach ($items as $item): ?&gt;
                    &lt;tr&gt;
                        &lt;td&gt;&lt;?php echo $item[&#039;id&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo $item[&#039;name&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo $item[&#039;price&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo $item[&#039;quantity&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo $item[&#039;total&#039;]; ?&gt;&lt;/td&gt;
                    &lt;/tr&gt;
                &lt;?php endforeach; ?&gt;
            &lt;/tbody&gt;
        &lt;/table&gt;
        &lt;button type=&quot;button&quot; id=&quot;submitBtn&quot;&gt;Hold the Transaction&lt;/button&gt; &lt;!-- Add the submit button --&gt;
    &lt;/form&gt;
&lt;/div&gt;

&lt;!-- Add the JavaScript code to handle form submission and redirection --&gt;
&lt;script&gt;
document.getElementById(&#039;submitBtn&#039;).addEventListener(&#039;click&#039;, function() {
    document.getElementById(&#039;holdForm&#039;).submit(); // Submit the form when the button is clicked
});

document.getElementById(&#039;holdForm&#039;).addEventListener(&#039;submit&#039;, function(event) {
    event.preventDefault(); // Prevent the default form submission behavior

    // Perform any necessary form validation here
    
    // Redirect after form submission
    window.location.href = &#039;pos.php&#039;; // Redirect to pos.php
});
&lt;/script&gt;
&lt;/body&gt;
&lt;/html&gt;

&lt;?php }?&gt;</code></pre>        </div>
    </div>