<?php

$con=mysqli_connect("localhost","u915722082_adminConsole","invoice@TDS2025","u915722082_invoice"); 

// $con=mysqli_connect("localhost","root","","invoice"); 

//   if(!$con){
// 	echo "Database Failed";
//   } else{
// 	echo "Database Connected";
//   }



  $UOM=["CTN","MTR","SET","KGS","MTS","BOX","NOS","PCS","LTRS"];
	
	date_default_timezone_set("Asia/Kolkata");
	
	if (!$con) {
		die ('Failed to connect to MySQL: ');
	}
	
	#site name
	define('SITENAME','Metronic');
	
	function getPageName(){
		return basename($_SERVER["PHP_SELF"]);
		
	}
	
	#day different
	function days_different($to,$from=""){
		if($from==""){
			$from=date("Y-m-d");
		}
		$first_date = strtotime($from);
		$second_date = strtotime($to);
		$datediff = $second_date - $first_date;

		return round($datediff / (60 * 60 * 24));
	}
	define('GST',18);	
	
	$USER_ROLLS=["Admin","Branch"];

	#get result set
	function resultSet($con,$sql){
		$res=$con->query($sql);
		#return $res->fetch_all(MYSQLI_ASSOC);
		$rows=[];
        while($row=$res->fetch_assoc()){
        	$rows[]=$row;
        }
        return $rows;
	}
	
	#get single row
	function single($con,$sql){
		$res=$con->query($sql);
		return $res->fetch_assoc();
	}
	
	#number format
	function format($num,$digit=2){
		$num=round($num,$digit);
		return number_format($num,$digit,".","");
    }
	
	#db to user format
	function date_user_format($date){
		return date("d-m-Y",strtotime($date));
    }
	
	#user to db format
	function date_db_format($date){
		return date("Y-m-d",strtotime($date));
    }

	#get random text
	function randText($randTextLength = 6) {
		$texts = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
		$textsLength = strlen($texts);
		$randTxt = "";
		for($i=0;$i<$randTextLength;$i++){
		  $n=rand(0,$textsLength-1);
		  $randTxt .= $texts[$n];
		}
		return $randTxt;
	}
  
	#Load Select Tag
	function loadSelect($con,$sql,$valueMember,$displayMember,$selectedIndex=null)
	{
		$res=$GLOBALS["con"]->query($sql);
		$options="<option value=''>Select</option>";
		if($res->num_rows>0)
		{
			while($row=$res->fetch_assoc())
			{
				if($selectedIndex==$row[$valueMember])
				{
					$options.="<option selected value='{$row[$valueMember]}'>{$row[$displayMember]}</option>";
				}
				else
				{
					$options.="<option value='{$row[$valueMember]}'>{$row[$displayMember]}</option>";
				}
			}
		}
		return $options;
	}
	
	#Get Query Count
	function getCount($sql)
	{
		$res=$GLOBALS["con"]->query($sql);
		return $res->num_rows;
	}
	
	#page redirect
	function redirect($link){
		echo "<script>location.replace('{$link}');</script>";
	}
	#flash message
	function flash($name='',$msg='',$cate='primary'){
		if(!empty($name)){
		  if(!empty($msg)&&empty($_SESSION[$name])){
			$_SESSION[$name]=$name;
			$_SESSION[$name."_msg"]=$msg;
			$_SESSION[$name."_cate"]=$cate;
		  }
		  else if(empty($msg)&&!empty($_SESSION[$name])){
		
			
			echo "
				<div class='alert alert-dismissible bg-light-{$_SESSION[$name."_cate"]} d-flex flex-column flex-sm-row p-5 mb-10'>
					<!--begin::Icon-->
					<i class='ki-duotone ki-search-list fs-1 text-{$_SESSION[$name."_cate"]} me-4 mb-5 mb-sm-0'><span class='fa fa-check-square'></span></i>
					<!--end::Icon-->

					<!--begin::Wrapper-->
					<div class='d-flex flex-column pe-0 pe-sm-10'>
						<!--begin::Title-->
						<h4 class='fw-semibold'>Action Status</h4>
						<!--end::Title-->

						<!--begin::Content-->
						<span>{$_SESSION[$name."_msg"]}</span>
						<!--end::Content-->
					</div>
					<!--end::Wrapper-->

					<!--begin::Close-->
					<button type='button' class='position-absolute position-sm-relative m-2 m-sm-0 top-0 end-0 btn btn-icon ms-sm-auto' data-bs-dismiss='alert'>
						<i class='ki-duotone ki-cross text-{$_SESSION[$name."_cate"]}'>
						<span class='fa fa-close'></span>
						</i>
					</button>
					<!--end::Close-->
				</div>
				";
			unset($_SESSION[$name]);
			unset($_SESSION[$name."_msg"]);
			unset($_SESSION[$name."_cate"]);
		  }
		}
	}

	function flashN($name='',$title='',$msg='',$cate='primary'){
		if(!empty($name)){
		  if(!empty($msg)&&empty($_SESSION[$name])){
			$_SESSION[$name]=$name;
			$_SESSION[$name."_title"]=$title;
			$_SESSION[$name."_msg"]=$msg;
			$_SESSION[$name."_cate"]=$cate;
		  }
		  else if(empty($msg)&&!empty($_SESSION[$name])){
		
			
			echo "
				<div class='alert alert-dismissible bg-light-{$_SESSION[$name."_cate"]} d-flex flex-column flex-sm-row p-5 mb-10'>
					<!--begin::Icon-->
					<i class='ki-duotone ki-search-list fs-1 text-{$_SESSION[$name."_cate"]} me-4 mb-5 mb-sm-0'><span class='fa fa-check-square'></span></i>
					<!--end::Icon-->

					<!--begin::Wrapper-->
					<div class='d-flex flex-column pe-0 pe-sm-10'>
						<!--begin::Title-->
						<h4 class='fw-semibold'>{$_SESSION[$name."_title"]}</h4>
						<!--end::Title-->

						<!--begin::Content-->
						<span>{$_SESSION[$name."_msg"]}</span>
						<!--end::Content-->
					</div>
					<!--end::Wrapper-->

					<!--begin::Close-->
					<button type='button' class='position-absolute position-sm-relative m-2 m-sm-0 top-0 end-0 btn btn-icon ms-sm-auto' data-bs-dismiss='alert'>
						<i class='ki-duotone ki-cross text-{$_SESSION[$name."_cate"]}'>
						<span class='fa fa-close'></span>
						</i>
					</button>
					<!--end::Close-->
				</div>
				";
			unset($_SESSION[$name]);
			unset($_SESSION[$name."_msg"]);
			unset($_SESSION[$name."_cate"]);
		  }
		}
	}
	

	
	//Current Date
	define('CURRENT_DATE',date("d-m-Y"));
?>