db connected


<form action="salesreport.php" method="post" enctype="multipart/form-data" id="frmreport" name="frmreport">
    <span style="padding:20px;"><input type="radio" name="rtype" value="detail" checked> Detail </span>
   <span style="padding:20px;"> <input type="radio" name="rtype" value="summary"> Summary</span>
<span style="padding:20px;"> Week:  <select id="wyear">
    <option value='01-2026'>2026-11-05-0000-00-00</option><option value='20-2026'>2026-05-11-2026-05-17</option><option value='18-2026'>2026-04-27-2026-05-03</option><option value='11-2026'>2026-03-09-2026-03-15</option><option value='10-2026'>2026-03-02-2026-03-08</option><option value='01-'>0000-00-00-0000-00-00</option><option value='10-2026'>0000-00-00-2026-03-05</option></select></span>
 <span style="padding:20px;">Branch: <select id="branch">
    <option value="">select branch</option>
    <option value='Summit'>Summit</option><option value='Bethel'>Bethel</option><option value='FiyelBet'>FiyelBet</option><option value=''></option><option value='Ayat'>Ayat</option></select></span>
<span style="padding:20px;">
<select id="section" placeholder="section">
    <option value=''>Section</option>
    
</select></span>
</form>
<div id='msg'>msg</div>
<div id="export">Export excel</div>
<script>
    const form = document.querySelector('form');
form.addEventListener('change', (event) => {
  if (event.target.type === 'radio') {
    console.log("Newly checked radio value:", event.target.value);
        let section = document.getElementById("section").value;
     let branch=document.getElementById("branch").value;
     let wyear=document.getElementById("wyear").value;
     const form = document.forms['frmreport'];
const rtype = form.elements['rtype'].value;
     if(section==="")
     {
        return;
     }
     fetch("getreport.php?section=" + section+"&branch="+branch+"&wyear="+wyear+"&rtype="+rtype)
        .then(response => response.json())
        .then(data => {
            let msg = document.getElementById('msg');
            console.log(data);
           
                 msg.innerHTML = data.rtn;
            
        })
        .catch(err => console.log(err));
  }
});

document.getElementById('section').addEventListener('change', function () {
     let section = this.value;
     let branch=document.getElementById("branch").value;
     let wyear=document.getElementById("wyear").value;
     const form = document.forms['frmreport'];
const rtype = form.elements['rtype'].value;
     if(section==="")
     {
        return;
     }
     fetch("getreport.php?section=" + section+"&branch="+branch+"&wyear="+wyear+"&rtype="+rtype)
        .then(response => response.json())
        .then(data => {
            let msg = document.getElementById('msg');
            console.log(data);
           
                 msg.innerHTML = data.rtn;
            
        })
        .catch(err => console.log(err));
//alert(section);

});

document.getElementById('export').addEventListener('click', function () {
  let msgx = document.getElementById("msg").innerHTML;
const params = new URLSearchParams({
  excel: msgx
});
//alert(msgx);
if(msgx.length>6)
{
    var myj = {
        excel: msgx,
        filename: "reportxls.xls"
    };

        var form = document.createElement('form');
        form.method = 'POST';
        form.action = 'default.php';
        form.target = '_blank';  // open in new tab/window

        var input = document.createElement('input');
        input.type = 'hidden';
        input.name = 'data';
        input.value = JSON.stringify(myj);

        form.appendChild(input);
        document.body.appendChild(form);
        form.submit();
 }
});

document.getElementById('branch').addEventListener('change', function () {
    let catId = this.value;
//alert(catId);
    if (catId === "") {
        return;
    }
    fetch("getselect.php?branch=" + catId)
        .then(response => response.json())
        .then(data => {
            let subSelect = document.getElementById('section');
            subSelect.innerHTML = "<option value=''>Section</option>";

            data.forEach(row => {
                subSelect.innerHTML += `<option value="${row.section}">${row.section}</option>`;
            });
        })
        .catch(err => console.log(err));
});

function calledfill(url,xvar,key,idselect)
{
     fetch(url+"?"+xvar+"=" + idselect)
        .then(response => response.json())
        .then(data => {
            let subSelect = document.getElementById('subcategory');
            subSelect.innerHTML = "<option value=''>Select Sub Category</option>";

            data.forEach(row => {
                subSelect.innerHTML += `<option value="${row.id}">${row.name}</option>`;
            });
        })
        .catch(err => console.log(err));
}

</script>