https://www.youtube.com/watch?v=vvWetw5PvMw

https://www.youtube.com/watch?v=HZarmNqfL7s

https://www.youtube.com/watch?v=7efeIJ7oFTc

https://www.youtube.com/watch?v=rRBWUPlpSNw

https://www.youtube.com/watch?v=zc-XwaUZkIg


https://pitscon-academy.blogspot.com/2023/03/how-to-print-in-pos-printer-xprinter-58.html


https://fontawesome.com/v4/icon/print

SELECT
    DATE_FORMAT(t.transaction_date, '%Y-%m') AS month,
    DATE_FORMAT(t.transaction_date, '%M %Y') AS month_label,
    SUM(COALESCE(i.amount, 0)) AS total_income,
    SUM(COALESCE(e.amount, 0)) AS total_expense,
    (
    SELECT
        SUM(
            COALESCE(i2.amount, 0) - COALESCE(e2.amount, 0)
        )
    FROM
        transactions t2
    LEFT JOIN income i2 ON
        t2.transaction_id = i2.transaction_id
    LEFT JOIN expense e2 ON
        t2.transaction_id = e2.transaction_id
    WHERE
        DATE_FORMAT(t2.transaction_date, '%Y-%m') <= DATE_FORMAT(t.transaction_date, '%Y-%m')
) AS running_balance
FROM
    transactions t
LEFT JOIN income i ON
    t.transaction_id = i.transaction_id
LEFT JOIN expense e ON
    t.transaction_id = e.transaction_id
GROUP BY
    DATE_FORMAT(t.transaction_date, '%Y-%m')
ORDER BY
    MONTH;

SELECT 'Income' AS type, SUM(amount) AS total FROM income
UNION ALL
SELECT 'Expense', SUM(amount) FROM expense
UNION ALL
SELECT 'Balance', 
       (SELECT SUM(amount) FROM income) - (SELECT SUM(amount) FROM expense);


SELECT 
  (SELECT SUM(amount) FROM income) AS tot_in,
  (SELECT SUM(amount) FROM expense) AS tot_ex,
  ((SELECT SUM(amount) FROM income) - (SELECT SUM(amount) FROM expense)) AS 'balance';
       
       

const Toast = Swal.mixin({
  toast: true,
  position: "top-end",
  showConfirmButton: false,
  timer: 3000,
  timerProgressBar: true,
  didOpen: (toast) => {
    toast.onmouseenter = Swal.stopTimer;
    toast.onmouseleave = Swal.resumeTimer;
  }
});
Toast.fire({
  icon: "success",
  title: "Signed in successfully"
});


SELECT
    i.`id`,
    `auto_gen_id`,
    `invoice_no`,
    `sub_total`,
    `discount`,
    `total_amount`,
    `paid_amount`,
    `balance`,
    i.`created_at`,
    i.`is_deleted`,
    #orders
    o.`amount`,
    #subcat
    `sub_category_name`,
    `price`,
    #cat
    `category_name`,
    #users
    `username`
FROM
    `invoices` i,
    `orders` o,
    `sub_category` sc,
    `category` c,
    `app_users` au
WHERE
    c.id = sc.category_id AND i.id = o.invoice_id AND sc.id = o.sub_cat_id AND au.id = i.user_id
    AND i.invoice_no = '0001'








SELECT 
    t.transaction_id,
    t.description,
    COALESCE(i.amount, 0) AS income,
    COALESCE(e.amount, 0) AS expense,
    t.balance
FROM transactions t
LEFT JOIN income i ON t.transaction_id = i.transaction_id
LEFT JOIN expense e ON t.transaction_id = e.transaction_id
ORDER BY t.transaction_id;


SELECT 
    t.transaction_id,
    t.description,
    COALESCE(i.amount, 0) AS income,
    COALESCE(e.amount, 0) AS expense,
    (
        SELECT 
            SUM(COALESCE(i2.amount, 0) - COALESCE(e2.amount, 0))
        FROM transactions t2
        LEFT JOIN income i2 ON t2.transaction_id = i2.transaction_id
        LEFT JOIN expense e2 ON t2.transaction_id = e2.transaction_id
        WHERE t2.transaction_id <= t.transaction_id
    ) AS running_balance
FROM transactions t
LEFT JOIN income i ON t.transaction_id = i.transaction_id
LEFT JOIN expense e ON t.transaction_id = e.transaction_id
ORDER BY t.transaction_id;


  function calculateSubtotal() {
      let subtotal = 0;
      const priceInputs = document.querySelectorAll('.price'); // Select all price inputs
      priceInputs.forEach(input => {
          const price = parseFloat(input.value); // Parse the value as a float
          if (!isNaN(price)) { // Check if the parsed value is a valid number
              subtotal += price; // Add to the subtotal
          }
      });

      const subtotalElement = document.getElementById('sub_total');
      subtotalElement.textContent = subtotal.toFixed(2); // Display the subtotal, formatted to 2 decimal places
  }

$.ajax({
  url: 'process.php',
  type: 'POST',
  data: { category_id: catId, action: 'fetch_subcategories' },
  success: function(response) {
    let rowNo = extractRowNumber(id);
    let subCategorySelect = $("#parent_category" + rowNo);
    subCategorySelect.empty(); // Clear existing options
    subCategorySelect.append("<option value='' disabled selected>Select Sub Category</option>");
    response.data.forEach(function(subCategory) {
      subCategorySelect.append("<option value='" + subCategory.id + "'>" + subCategory.name + "</option>");
    });
    $("#price" + rowNo).val(response.data[0].price); // Set the price in the input field
  },
  error: function(xhr, status, error) {
    console.log('Error:', error);
  }
});

sql query
SELECT
    LPAD(`invoice_no`, 4, '0') AS formatted_invoice_number
FROM
    invoices;
    
    

<tr>
                            <td>
                                Bilan Arabeti
                            </td>
                            <td> INV001 </td>
                            <td> $88.65 </td>
                            <td>
                              <label class="badge badge-gradient-warning">PROGRESS</label>
                            </td>
                            <td> Dec 3, 2017 </td>
                          </tr>
                          <tr>
                            <td>
                                Abdullahi Liiji
                            </td>
                            <td> INV003 </td>
                            <td> $65.65 </td>
                            <td>
                              <label class="badge badge-gradient-success">DONE</label>
                            </td>
                            <td> Dec 3, 2017 </td>
                          </tr>
                          <tr>
                            <td>
                                Bilan Arabeti
                            </td>
                            <td> INV009 </td>
                            <td> $88.65 </td>
                            <td>
                              <label class="badge badge-gradient-info">ON HOLD</label>
                            </td>
                            <td> Dec 3, 2017 </td>
                          </tr>
                          <tr>
                            <td>
                                Abdullahi Liiji
                            </td>
                            <td> INV006 </td>
                            <td> $65.65 </td>
                            <td>
                              <label class="badge badge-gradient-danger">REJECTED</label>
                            </td>
                            <td> Dec 3, 2017 </td>
                          </tr>