<?php
include 'include/conf.php';
function generate($comp_id, $conn)
{
    $get_comp = mysqli_query($conn, "SELECT `name`, `map_url` from tbl_company where id='$comp_id'");
    $set_comp = mysqli_fetch_assoc($get_comp);
    $fina_year=getFinancialYear();
     $inv_pre = $set_comp['map_url'].'-'.$fina_year.'-';
    // $inv_pre = $set_comp['map_url'];
    $get_inv = mysqli_query($conn, "SELECT * FROM tbl_confirmorder  WHERE varstatus!='Cash' and company_name='".$set_comp['name']."' and refid like '%$inv_pre%' order by orid desc limit 1");
    $check_rows = mysqli_num_rows($get_inv);
    if($check_rows > 0){
        $set_inv = mysqli_fetch_assoc($get_inv);
        $exp = explode("-", $set_inv['refid']);
        $seq = (int)$exp[2] + 1;
        $formatted_seq = str_pad($seq, 4, '0', STR_PAD_LEFT);
        $inv_no = $exp[0].'-'.$exp[1].'-'.$formatted_seq;
    }else{
        $inv_no = $set_comp['map_url'].'-'.$fina_year.'-0001';
    }
     return $inv_no;
}

function getFinancialYear() {
    $currentMonth = date('n'); // Numeric representation of a month (1 to 12)
    $currentYear = date('Y');

    if ($currentMonth >= 4) {
        $startYear = $currentYear;
        $endYear = $currentYear + 1;
    } else {
        $startYear = $currentYear - 1;
        $endYear = $currentYear;
    }

    // return $startYear . '-' . substr($endYear, -2); // e.g., "2024-25"
     return $startYear;
}
echo generate('2', $conn);
echo generate('10', $conn);
?>