<?php
/*BOF special functions define here by Solar IT*/

function reportMonthlyAccessorySaleDealer($classBusiLogic, $subAction, $classSpecial) {

	if (!isset($_POST['submitForm'])) {
		$RefreshMin	= 0;
		$arrCompanyMDisp = $classBusiLogic->getCompanyMDisp();
		$arrCustomerMDisp = $classBusiLogic->getCustomerMDisp();
		$utilityName = 'reportMonthlyAccessorySaleDealer';
		include_once("special/spl.form.ReportPara.php");
	} else {

		$data = $_POST;
		$DTS		= $data['DTS'];
		$DTE		= $data['DTE'];
		$CompanyCd		= $data['CompanyCd'];
		$DTSAnsi	= $classBusiLogic->convertDate($DTS, TRUE, 1);
		$DTEAnsi	= $classBusiLogic->convertDate($DTE, TRUE, 1);
		$accessory_details = array();
		if(isset($_GET['id']) && $_GET['id'] !=''){
			$CustomerCd	= $_GET['id'];
			$resultArr = $classSpecial->reportMonthlyAccessorySaleDealer($DTS, $DTE, $CompanyCd, $CustomerCd);
			$accessory_details = $resultArr;
		}else{
			if(isset($_SESSION['IsCustomer']) && $_SESSION['IsCustomer'] =='1'){
				$CustomerCd	= $_SESSION['CustomerCd'];
			}else{
				$CustomerCd	= (isset($data['CustomerCd']) ? $data['CustomerCd'] : '0');
			}
			$resultArr = $classSpecial->reportMonthlyAccessorySaleDealer($DTS, $DTE, $CompanyCd, $CustomerCd);
			
			if(is_array($resultArr) && !empty($resultArr)) {
			for($i=0;$i<sizeof($resultArr);$i++){
				
				$CustomerCd_ID = $resultArr[$i]['Customer'];
				$accessory_CustomerCd_ID[] = $CustomerCd_ID;
				$CustomerCd_Name = str_replace(','.$resultArr[$i]['Station'],'',$resultArr[$i]['Dealer']);
				$accessory_details['CustomerCd_ID'][] = $CustomerCd_ID;
				$accessory_details['Name'][] = $CustomerCd_Name;
				$accessory_details['Station'][] = $resultArr[$i]['Station'];
				
				if($resultArr[$i]['ItemName'] == 'Ecodet') {
					if(array_key_exists('Ecodet', $accessory_details) == true && !empty($accessory_details['Ecodet']) && array_key_exists($CustomerCd_ID, $accessory_details['Ecodet']) == true){
						$accessory_details['Ecodet'][$CustomerCd_ID] = $accessory_details['Ecodet'][$CustomerCd_ID] + $resultArr[$i]['Total_Mtr'];
					}else{
						$accessory_details['Ecodet'][$CustomerCd_ID] = $resultArr[$i]['Total_Mtr'];
					}
				}
				
				if($resultArr[$i]['ItemName'] == 'Supremedet') {
					if(array_key_exists('Supremedet', $accessory_details) == true && !empty($accessory_details['Supremedet']) && array_key_exists($CustomerCd_ID, $accessory_details['Supremedet']) == true){
						$accessory_details['Supremedet'][$CustomerCd_ID] = $accessory_details['Supremedet'][$CustomerCd_ID] + $resultArr[$i]['Total_Mtr'];
					}else{
						$accessory_details['Supremedet'][$CustomerCd_ID] = $resultArr[$i]['Total_Mtr'];
					}
				}

				if($resultArr[$i]['ItemName'] == 'Solardet') {
					if(array_key_exists('Solardet',$accessory_details) == true && !empty($accessory_details['Solardet']) && array_key_exists($CustomerCd_ID, $accessory_details['Solardet']) == true){
						$accessory_details['Solardet'][$CustomerCd_ID] = $accessory_details['Solardet'][$CustomerCd_ID] + $resultArr[$i]['Total_Qty'];
					}else{
						$accessory_details['Solardet'][$CustomerCd_ID] = $resultArr[$i]['Total_Qty'];
					}
				}
				
				if($resultArr[$i]['ItemName'] == 'LDS') {
					if(array_key_exists('LDS',$accessory_details) == true && !empty($accessory_details['LDS']) && array_key_exists($CustomerCd_ID, $accessory_details['LDS']) == true){
						$accessory_details['LDS'][$CustomerCd_ID] = $accessory_details['LDS'][$CustomerCd_ID] + $resultArr[$i]['Total_Mtr'];
					}else{
						$accessory_details['LDS'][$CustomerCd_ID] = $resultArr[$i]['Total_Mtr'];
					}
				}
				
				if($resultArr[$i]['ItemName'] == 'LDD SDD 3 Mtr') {
					if(array_key_exists('LDD_SDD_3',$accessory_details) == true && !empty($accessory_details['LDD_SDD_3']) && array_key_exists($CustomerCd_ID, $accessory_details['LDD_SDD_3']) == true){
						$accessory_details['LDD_SDD_3'][$CustomerCd_ID] = $accessory_details['LDD_SDD_3'][$CustomerCd_ID] + $resultArr[$i]['Total_Qty'];				 
					}else{
						$accessory_details['LDD_SDD_3'][$CustomerCd_ID] = $resultArr[$i]['Total_Qty'];
					}
				}
				
				if($resultArr[$i]['ItemName'] == 'LDD SDD 5 Mtr') {
					if(array_key_exists('LDD_SDD_5', $accessory_details) == true && !empty($accessory_details['LDD_SDD_5']) && array_key_exists($CustomerCd_ID, $accessory_details['LDD_SDD_5']) == true){
						$accessory_details['LDD_SDD_5'][$CustomerCd_ID] = $accessory_details['LDD_SDD_5'][$CustomerCd_ID] + $resultArr[$i]['Total_Qty'];				 
					}else{
						$accessory_details['LDD_SDD_5'][$CustomerCd_ID] = $resultArr[$i]['Total_Qty'];	
					}
				}
					
				if($resultArr[$i]['ItemName'] == 'Relay Order') {
					if(array_key_exists('Relay',$accessory_details) == true && !empty($accessory_details['Relay']) && array_key_exists($CustomerCd_ID, $accessory_details['Relay']) == true){
						$accessory_details['Relay'][$CustomerCd_ID] = $accessory_details['Relay'][$CustomerCd_ID] + $resultArr[$i]['Total_Qty'];
					}else{
						$accessory_details['Relay'][$CustomerCd_ID] = $resultArr[$i]['Total_Qty'];
					}
				}
			}
			
			$accessory_details['CustomerCd_ID'] = array_unique($accessory_details['CustomerCd_ID']);
			}
		}


		$count = 0;
		$ecodet_total_qty = 0;
		$supremedet_total_qty = 0;
		$solardet_total_qty = 0;
		$lds_total_qty = 0;
		$lddsdd3_total_qty = 0;
		$lddsdd5_total_qty = 0;
		$relay_total_qty = 0;
		
		require_once("./special/spl.rep.MonthlyAccessorySaleDealer.php");

	}
}

function shortreportDailyStock($classBusiLogic, $IsAED)
{
    if (!isset($_POST['submitForm'])) {
        $RefreshMin  = 0;
        $utilityName = ($IsAED ? 'shortreportDailyStockAED' : 'shortreportDailyStockExpl');
        include_once("special/spl.form.ReportPara.php");
    } else {
        $data          = $_POST;
        $DTSDays       = $data['DTSDays'];
        $DTE           = $data['DTE'];
        $DTEAnsi       = $classBusiLogic->convertDate($DTE, TRUE, 1);
        $DTS           = $classBusiLogic->addDate($DTEAnsi, '-' . $data['DTSDays'] . ' day', TRUE);
        $BreakColNames = 'State,CustomerCtg';
        include_once("./special/spl.rep.DailyStock.php");
    }
}

// Target Monthly -----------------------------------------------------------------------------------------------------------------------------------------
function viewSubDealerTargetMonth($classBusiLogic, $StatusFilter, $classSpecial) {
// $StatusFilter>> -1:InternalCall. 0:New/All, 1:Unapproved(Allow mass Approval), 2:Approved
	checkAccessLevel();
	if ($StatusFilter != -1) {
		$_SESSION['StatusFilter'] = $StatusFilter;
	}
	$searchVal = isset($_POST['searchVal']) ? $_POST['searchVal'] : NULL;
	
	$TargetForMY = $classBusiLogic->getTargetForMY();
	$listData = $classSpecial->getSubDealerTargetMonthList($searchVal, $TargetForMY);
	$IsAllowTgrt = 0;
	if(!empty($listData)) {
		$IsAllowTgrt = $listData[0]['AllowTrgt'];
	}
	include_once("./special/spl.form.SubDealerTargetMonth.list.php");
}

function createSubDealerTargetMonth($classBusiLogic,$classSpecial) {
	checkAccessLevel();
	$inEditMode = FALSE;
	$StatusCd = "U";
	$SubdealerCd = '';
	$SrNo = 0;
	if($_SESSION['SubdealerCd'] !=''){
		$SubdealerCd = $_SESSION['SubdealerCd'];
	}
	$arrSubDealerItemMDisp	= $classSpecial->getSubDealerItemMDisp($SubdealerCd);
	//echo $arrSubDealerItemMDisp;
	if (!isset($_POST['submitForm'])) {
		
		if($SubdealerCd !=''){		
			$arrSubDealerCustomerMDisp	= $classSpecial->getSubDealerCustomerMDisp($SubdealerCd);			
		}else{
			$arrCustomerMDisp	= $classBusiLogic->getCustomerMDisp(2);
		}
		$arrStatusMDisp		= $classBusiLogic->getStatusMDisp($StatusCd, 'M');
		$arrSubdealerMDisp		= $classBusiLogic->getSubdealerMDisp('', 'A.IdSubdealer='.$SubdealerCd);
		include_once("./special/spl.form.SubDealerTargetMonth.php");
	} else {
	
		$headerData = $_POST;
		if($headerData['Month'] == 13) $headerData['Month'] = '01'; 

		$result = $classSpecial->isExistSubDealerTargetMonth($headerData['SubdealerCd'],$headerData['Month'],$headerData['Year']);
		if ($result == 0) {
			//$classBusiLogic->manageTransaction(0);
			$failMsg = $classSpecial->insertSubDealerTargetMonth($headerData);
		
			if ($failMsg) {
			//	$classBusiLogic->manageTransaction(-1);
				//afterUpdate($failMsg);
			} else {
				$failMsg = $classSpecial->insertSubDealerTargetMonthItem($headerData);
				if($_SESSION['IsSubDealer']){
				$failMsg1 = $classSpecial->insertSubDealerTargetMonthItemStock($headerData);
				}
			
				if ($failMsg) {
				//	$classBusiLogic->manageTransaction(-1);
				//	afterUpdate($failMsg);
				} else {
					//$classBusiLogic->manageTransaction(1);
					echo "<script language='javascript'>window.location.href='index.php?action=viewSubDealerTargetMonth&subAction=1';</script>";
				}
			}
		
		} else {
			$arrCustomerMDisp	= $classSpecial->getSubDealerCustomerMDisp($_SESSION['SubdealerCd']);
			$arrStatusMDisp		= $classBusiLogic->getStatusMDisp($StatusCd, 'M');
			include_once("./special/spl.form.SubDealerTargetMonth.php");
			echo '<script>alert("This SubdealerCd+Customer+Year+Month Target already exists.")</script>';
		}	
	}
}

function editSubDealerTargetMonth($classBusiLogic,$classSpecial){
	checkAccessLevel();
	$inEditMode = TRUE;
	if (!isset($_POST['submitForm'])) {
		$SubdealerCd = '';
		$CustomerCd = '';

		if((isset($_SESSION['SubdealerCd']) && $_SESSION['SubdealerCd'] != '') || (isset($_GET['SubdealerCd']) || $_GET['SubdealerCd'])){
			$SubdealerCd = (isset($_GET['SubdealerCd']) ? $_GET['SubdealerCd'] : $_SESSION['SubdealerCd']);
		}

		if((isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] != '') || (isset($_GET['CustomerCd']) || $_GET['CustomerCd']) ){
			$CustomerCd = (isset($_GET['CustomerCd']) ? $_GET['CustomerCd'] : $_SESSION['CustomerCd']);
		}

		$Month = (isset($_GET['Month']) ? $_GET['Month'] : '');
		$Year = (isset($_GET['Year']) ? $_GET['Year'] : '');
		$headerData	 = $classSpecial->getSubDealerTargetMonthHeader($SubdealerCd, $CustomerCd, $Month, $Year);

		$totalData = sizeof($headerData);
		$totalApproved = 0;
		foreach ($headerData as $key => $value){
			if($headerData[$key]['StatusCd'] == 'A') $totalApproved++;
		}

		$arrSubDealerCustomerMDisp	= $classSpecial->getSubDealerCustomerMDisp($SubdealerCd, $CustomerCd);
		$arrSubDealerItemMDisp = $classSpecial->getSubDealerTargetMonthItemStock($headerData[0]['SubdealerCd'], $CustomerCd, $headerData[0]['Year'], $headerData[0]['Month']);		
		$arrStatusMDisp		= $classBusiLogic->getStatusMDisp($headerData[0]['StatusCd'], 'M');
		$arrSubdealerMDisp		= $classBusiLogic->getSubdealerMDisp($headerData[0]['CustomerCd'], 'A.IdSubdealer='.$SubdealerCd);
		include_once("./special/spl.form.SubDealerTargetMonth.php");
	} else {
		$headerData	= $_POST;

		$classBusiLogic->manageTransaction(0);
		$failMsg	= $classSpecial->updateSubDealerTargetMonth($headerData);
		if ($failMsg) {			
			$classBusiLogic->manageTransaction(-1);
			afterUpdate($failMsg);
		} else {			
			$failMsg = $classSpecial->updateSubDealerTargetMonthItem($headerData);
			if ($failMsg) {		
				$classBusiLogic->manageTransaction(-1);
				afterUpdate($failMsg);
			} else {
				$classBusiLogic->manageTransaction(1);
				checkSubDealerTargetMonthApprove($classSpecial, $headerData);
				echo '<script language="javascript">window.location.href="index.php?action=viewSubDealerTargetMonth&subAction=1";</script>';
			}			
		}
	}
}

function checkSubDealerTargetMonthApprove($classSpecial, $headerData) {
	
	$condTarget = "SubdealerCd='" . $headerData['SubdealerCd'] . "' AND CustomerCd='" . $headerData['oldCustomerCd'] . "' AND YMFlag=1 AND Year='" . $headerData['Year'] . "' AND Month=" . $headerData['Month'] ;

	if (isset($headerData['StatusCd']) && $headerData['StatusCd']=="A" && empty($headerData['ApprovedByUserName'])) {
		$classSpecial->approveSubDealerTargetMonth($condTarget, TRUE);
	}else if (isset($headerData['StatusCd']) && $headerData['StatusCd']=="U" && !empty($headerData['ApprovedByUserName'])) {
		$classSpecial->approveSubDealerTargetMonth($condTarget, FALSE);
	}else{
		$classSpecial->approveSubDealerTargetMonth($condTarget, FALSE);
	}
}

function approveSubDealerTargetMonth($classSpecial) {

	checkAccessLevel();
	if (isset($_GET['act'])) {
		$condTarget = $_GET['act'];
		$failMsg = $classSpecial->approveSubDealerTargetMonth($condTarget, TRUE);
		$failMsg = '';
		afterUpdate($failMsg, "viewSubDealerTargetMonth");
	}
}

function reportSubdealerTargetMonthly($classBusiLogic,$classSpecial) {
	if (!isset($_POST['submitForm'])) {		
		$utilityName = 'reportSubdealerTargetMonthly';
		$CustomerCd = '';
		if($_SESSION['CustomerCd'] !=''){
			$CustomerCd = $_SESSION['CustomerCd'];
		}
		$arrSubdealerMDisp	= $classBusiLogic->getSubdealerMDisp($CustomerCd);
		include_once("./special/spl.form.ReportPara.php");
	} else {
		$IdSubdealer = '';
		$CustomerCd = '';
		$ItemArray = '';
		$ItemCount = '';
		$url = '';
		$count = 0;
		$headerData = $_POST;
		if($_SESSION['CustomerCd'] !=''){
			$CustomerCd = $_SESSION['CustomerCd'];
		}

		$SubdealerTgtRep = $classSpecial->reportSubdealerTargetMonthly($headerData);
		$ItemCount = 0;
		if(!empty($SubdealerTgtRep) && count($SubdealerTgtRep) > 0){
			$ItemArray = array_unique($SubdealerTgtRep['Item']);
			$ItemCount = count($ItemArray);
		}
		$MYS = $headerData['MYS'];
		$repType = $headerData['repType'];
		$url .= 'MYS='.$MYS.'&repType='.$repType;
		if(isset($headerData['IdSubdealer']) && $headerData['IdSubdealer'] !=''){
			$IdSubdealer = $headerData['IdSubdealer'];
			$url .='&IdSubdealer='.$IdSubdealer;
		}
		if($_SESSION['CustomerCd'] !=''){
			$CustomerCd = $_SESSION['CustomerCd'];
			$url .='&CustomerCd='.$CustomerCd;
		}
		if($_SESSION['IsSubDealer'] !=''){
			$IsSubDealer = $_SESSION['IsSubDealer'];
			$url .='&IsSubDealer='.$IsSubDealer;
		}

		include_once("./special/spl.rep.SubdealerTargetMonthly.php");
	}
}


//=====================================Subdealer Target Month Trade New====================

function viewSubDealerTradeTargetMonth($classBusiLogic, $StatusFilter, $classSpecial) {
// $StatusFilter>> -1:InternalCall. 0:New/All, 1:Unapproved(Allow mass Approval), 2:Approved
	checkAccessLevel();
	if ($StatusFilter != -1) {
		$_SESSION['StatusFilter'] = $StatusFilter;
	}
	$searchVal 		= isset($_POST['searchVal']) ? $_POST['searchVal'] : NULL;
	$TargetForMY 	= $classBusiLogic->getTargetForMY();
	$listData 		= $classSpecial->getSubDealerTradeTargetMonthList($searchVal, $TargetForMY);
	$IsAllowTgrt 	= 0;
	if(!empty($listData)) {
		$IsAllowTgrt = $listData[0]['AllowTrgt'];
	}
	include_once("./special/spl.form.SubDealerTargetMonth.list.Trade.php");
}

function createSubDealerTradeTargetMonth($classBusiLogic,$classSpecial) {
	checkAccessLevel();
	$inEditMode = FALSE;
	$StatusCd = "U";
	$SubdealerCd = '';
	$SrNo = 0;
	if($_SESSION['SubdealerCd'] !=''){
		$SubdealerCd = $_SESSION['SubdealerCd'];
	}
	$arrSubDealerItemMDisp	= $classSpecial->getSubDealerTradeItemMDisp($SubdealerCd);
	//echo $arrSubDealerItemMDisp;
	if (!isset($_POST['submitForm'])) {
		
		if($SubdealerCd !=''){		
			$arrSubDealerCustomerMDisp	= $classSpecial->getSubDealerCustomerMDisp($SubdealerCd);			
		}else{
			$arrCustomerMDisp	= $classBusiLogic->getCustomerMDisp(2);
		}
		$arrStatusMDisp		= $classBusiLogic->getStatusMDisp($StatusCd, 'M');
		$arrSubdealerMDisp		= $classBusiLogic->getSubdealerMDisp('', 'A.IdSubdealer='.$SubdealerCd);
		include_once("./special/spl.form.SubDealerTargetMonth.Trade.php");
	} else {
	
		$headerData = $_POST;
		//print_r($headerData);
		if($headerData['Month'] == 13) $headerData['Month'] = '01'; 

		$result = $classSpecial->isExistSubDealerTradeTargetMonth($headerData['SubdealerCd'],$headerData['Month'],$headerData['Year']);
		if ($result == 0) {
			//$classBusiLogic->manageTransaction(0);
			$failMsg = $classSpecial->insertSubDealerTradeTargetMonth($headerData);
		
			if ($failMsg) {
			//	$classBusiLogic->manageTransaction(-1);
				afterUpdate($failMsg);
				echo "<script language='javascript'>window.location.href='index.php?action=viewSubDealerTradeTargetMonth&subAction=1';</script>";
			} else {
				$failMsg = $classSpecial->insertSubDealerTradeTargetMonthItem($headerData);
				if($_SESSION['IsSubDealer']){
					$failMsg1 = $classSpecial->insertSubDealerTradeTargetMonthItemStock($headerData);
				}
				
				if ($failMsg) {
					//$classBusiLogic->manageTransaction(-1);
					afterUpdate($failMsg);
					
				} else {
					//$classBusiLogic->manageTransaction(1);
				echo "<script language='javascript'>window.location.href='index.php?action=viewSubDealerTradeTargetMonth&subAction=1';</script>";
				}
			}
		
		} else {
			$arrCustomerMDisp	= $classSpecial->getSubDealerCustomerMDisp($_SESSION['SubdealerCd']);
			$arrStatusMDisp		= $classBusiLogic->getStatusMDisp($StatusCd, 'M');
			include_once("./special/spl.form.SubDealerTargetMonth.Trade.php");
			echo '<script>alert("This SubdealerCd+Customer+Year+Month Target already exists.")</script>';
		}	
	}
}

function editSubDealerTradeTargetMonth($classBusiLogic,$classSpecial){
	checkAccessLevel();
	$inEditMode = TRUE;
	if (!isset($_POST['submitForm'])) {
		$SubdealerCd = '';
		$CustomerCd = '';

		if((isset($_SESSION['SubdealerCd']) && $_SESSION['SubdealerCd'] != '') || (isset($_GET['SubdealerCd']) || $_GET['SubdealerCd'])){
			$SubdealerCd = (isset($_GET['SubdealerCd']) ? $_GET['SubdealerCd'] : $_SESSION['SubdealerCd']);
		}

		if((isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] != '')){
			$CustomerCd = (isset($_GET['CustomerCd']) ? $_GET['CustomerCd'] : $_SESSION['CustomerCd']);
		}
	

		$Month = (isset($_GET['Month']) ? $_GET['Month'] : '');
		$Year = (isset($_GET['Year']) ? $_GET['Year'] : '');
		$arrSubDealerItemMDisp	= $classSpecial->getSubDealerTradeItemMDisp($SubdealerCd);
		//print_r($arrSubDealerItemMDisp);
		$headerData	 = $classSpecial->getSubDealerTradeTargetMonthHeader($SubdealerCd, $CustomerCd, $Month, $Year);

		$totalData = sizeof($headerData);
		$totalApproved = 0;
		foreach ($headerData as $key => $value){
			if($headerData[$key]['StatusCd'] == 'A') $totalApproved++;
		}
		$arrSubDealerCustomerMDisp	= $classSpecial->getSubDealerCustomerMDisp($SubdealerCd, $CustomerCd);
		$arrStatusMDisp		= $classBusiLogic->getStatusMDisp($headerData[0]['StatusCd'], 'M');
		$arrSubdealerMDisp	= $classBusiLogic->getSubdealerMDisp($headerData[0]['CustomerCd'], 'A.IdSubdealer='.$SubdealerCd);
		include_once("./special/spl.form.SubDealerTargetMonth.Trade.php");
	} else {
		$headerData	= $_POST;
//print_r($headerData);
		if($_SESSION['IsSubDealer'] && $headerData['StatusCd']=='U'){
			$failMsg	= $classSpecial->updateSubDealerTradeTargetMonthItemSub($headerData);
			$failMsg	= $classSpecial->updateSubDealerTradeTargetMonthStockSub($headerData);
		}
		else{
			$failMsg	= $classSpecial->updateSubDealerTradeTargetMonth($headerData);
			if ($failMsg) {			
				$classBusiLogic->manageTransaction(-1);
				afterUpdate($failMsg);
			} else {			
				$failMsg = $classSpecial->updateSubDealerTradeTargetMonthItem($headerData);
				if ($failMsg) {		
					$classBusiLogic->manageTransaction(-1);
					afterUpdate($failMsg);
				} else {
					$classBusiLogic->manageTransaction(1);
				//	checkSubDealerTradeTargetMonthApprove($classSpecial, $headerData);
				echo '<script language="javascript">window.location.href="index.php?action=viewSubDealerTradeTargetMonth&subAction=1";</script>';
				}			
			}
		}
	}
}

function checkSubDealerTargetTradeMonthApprove($classSpecial, $headerData) {
	
	$condTarget = "SubdealerCd='" . $headerData['SubdealerCd'] . "' AND CustomerCd='" . $headerData['oldCustomerCd'] . "' AND YMFlag=1 AND Year='" . $headerData['Year'] . "' AND Month=" . $headerData['Month'] ;

	if (isset($headerData['StatusCd']) && $headerData['StatusCd']=="A" && empty($headerData['ApprovedByUserName'])) {
		$classSpecial->approveSubDealerTargetMonth($condTarget, TRUE);
	}else if (isset($headerData['StatusCd']) && $headerData['StatusCd']=="U" && !empty($headerData['ApprovedByUserName'])) {
		$classSpecial->approveSubDealerTargetMonth($condTarget, FALSE);
	}else{
		$classSpecial->approveSubDealerTargetMonth($condTarget, FALSE);
	}
}



function reportSubdealerTradeTargetMonthly($classBusiLogic,$classSpecial) {
	if (!isset($_POST['submitForm'])) {		
		$utilityName = 'reportSubdealerTargetMonthly';
		$CustomerCd = '';
		if($_SESSION['CustomerCd'] !=''){
			$CustomerCd = $_SESSION['CustomerCd'];
		}
		$arrSubdealerMDisp	= $classBusiLogic->getSubdealerMDisp($CustomerCd);
		include_once("./special/spl.form.ReportPara.php");
	} else {
		$IdSubdealer = '';
		$CustomerCd = '';
		$ItemArray = '';
		$ItemCount = '';
		$url = '';
		$count = 0;
		$headerData = $_POST;
		if($_SESSION['CustomerCd'] !=''){
			$CustomerCd = $_SESSION['CustomerCd'];
		}

		$SubdealerTgtRep = $classSpecial->reportSubdealerTargetMonthly($headerData);
		$ItemCount = 0;
		if(!empty($SubdealerTgtRep) && count($SubdealerTgtRep) > 0){
			$ItemArray = array_unique($SubdealerTgtRep['Item']);
			$ItemCount = count($ItemArray);
		}
		$MYS = $headerData['MYS'];
		$repType = $headerData['repType'];
		$url .= 'MYS='.$MYS.'&repType='.$repType;
		if(isset($headerData['IdSubdealer']) && $headerData['IdSubdealer'] !=''){
			$IdSubdealer = $headerData['IdSubdealer'];
			$url .='&IdSubdealer='.$IdSubdealer;
		}
		if($_SESSION['CustomerCd'] !=''){
			$CustomerCd = $_SESSION['CustomerCd'];
			$url .='&CustomerCd='.$CustomerCd;
		}
		if($_SESSION['IsSubDealer'] !=''){
			$IsSubDealer = $_SESSION['IsSubDealer'];
			$url .='&IsSubDealer='.$IsSubDealer;
		}

		include_once("./special/spl.rep.SubdealerTargetMonthly.php");
	}
}






function approveItemSubDealerTradeTargetMonth($classBusiLogic,$classSpecial){
	if (!isset($_POST['submitForm'])) {
		$Month 			= $_GET['Month'];
		$Year  			= $_GET['Year'];
		$CustomerCd  	= $_GET['CustomerCd'];
		$SubDealerCd  	= $_GET['SubdealerCd'];
		$subDealerList	=  $classSpecial->subdealerTargetPercentageDetails($SubDealerCd,$CustomerCd);
		$listData 		=  $classSpecial->approveItemSubDealerTradeTargetMonthItem($Month, $Year,$SubDealerCd,$CustomerCd);
		include_once("./special/spl.form.approveItemSubDealerTradeTargetMonth.php");
	}else {
		$headerData  = $_POST;
		$failMsg	 =  $classSpecial->insertApproveItemSubDealerTradeTargetMonth($headerData);
		afterUpdate($failMsg, "viewSubDealerTradeTargetMonth");
	}
}



function approveSubDealerTradeTargetMonth($classSpecial) {
	checkAccessLevel();
	if (isset($_GET['act'])) {
		$condTarget = $_GET['act'];
		$failMsg = $classSpecial->approveSubDealerTargetMonthTrade($condTarget, TRUE);
		$failMsg = '';
		afterUpdate($failMsg, "viewSubDealerTradeTargetMonth");
	}
}



//===================================== End of Subdealer Target Month New====================





//Phone Call & Report Functionality

function PhoneCallList($classBusiLogic,$classSpecial){
	$searchVal='';
	if (isset($_GET['searchFlag'])) {
		$searchVal = $_POST['                                                                                  '];		
	}	
	if(isset($_GET['SearchDate']) && $_GET['SearchDate'] !='') {
			$SearchDate = $_GET['SearchDate'];
		}else{
			$SearchDate = date('d-m-Y');
	}
	$CustomerCd ='';
	$yesterday_record = '';
	if(isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] !=''){
		$CustomerCd = $_SESSION['CustomerCd'];
		$prev_date = date("Y-m-d", strtotime("yesterday"));
		$yesterday_record = $classSpecial->ChkSummaryReport($prev_date, $CustomerCd);
		$nillReport = $classSpecial->ChkSummaryReport(date("Y-m-d"), $CustomerCd,'Nil Record');
	}
	
	$listData = $classSpecial->getPhoneCallList($SearchDate, $CustomerCd, $searchVal);
	$count = count($listData);
	include_once("./special/spl.PhoneCallList.php");
}


function HighlightPhoneCallList($classBusiLogic,$classSpecial){
	$searchVal='';
	if (isset($_GET['searchFlag'])) {
		$searchVal = $_POST['searchVal'];		
	}	
	if(isset($_GET['SearchDate']) && $_GET['SearchDate'] !='') {
			$SearchDate = $_GET['SearchDate'];
		}else{
			$SearchDate = date('d-m-Y');
	}
	$CustomerCd ='';
	$yesterday_record = '';
	if(isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] !=''){
		$CustomerCd = $_SESSION['CustomerCd'];
		$prev_date = date("Y-m-d", strtotime("yesterday"));
		$yesterday_record = $classSpecial->ChkSummaryReport($prev_date, $CustomerCd);
		$nillReport = $classSpecial->ChkSummaryReport(date("Y-m-d"), $CustomerCd,'Nil Record');
	}
	
	$listData = $classSpecial->getHighlightPhoneCallList($SearchDate, $CustomerCd, $searchVal);
	$count = count($listData);
	include_once("./special/spl.HighlightPhoneCallList.php");
}

function createPhoneCall($classBusiLogic,$classSpecial){
	$inEditMode = false;
	if (!isset($_POST['submitForm'])) {
		$getCallType = $classSpecial->getCallType();		
		$headerData[0] = array('SubDealerCd'=>'', 'SubDealerName'=>'', 'call_type_cd'=>'', 'Station'=>'', 'StateCd'=>'', 'call_time'=>'00:00', 'Person'=>'', 'contact_medium'=>'', 'message'=>'', 'ContactBy'=>'','CustomerCd'=> $_SESSION['CustomerCd'],'CustomerName'=> $_SESSION['Customer'],'date_added'=>date('Y-m-d'));
		$arrSubdealerMDisp = $classBusiLogic->getSubdealerMDisp($headerData[0]['CustomerCd']);
	
		$current_date = date("Y-m-d");
		$nillReport = $classSpecial->ChkSummaryReport($current_date, $headerData[0]['CustomerCd']);
		$time = date('H:i:s');
		//echo $time;
		if($time >  '20:00:00'){
			echo '<script language="javascript"> alert("This Phone Call Report is not Submitted after 8:00 PM !!");
			window.location.href="index.php?action=PhoneCallList";</script>';
		}
		include_once("./special/spl.form.PhoneCall.php");		
	}else{
		$headerData = $_POST;
	
		$fail_msg = $classSpecial->insertPhoneCall($headerData);
		if(!$fail_msg){
			echo '<script language="javascript"> alert("Phone Call Created Successfully!!");
			window.location.href="index.php?action=PhoneCallList";</script>';
		}
	}	
}

function editPhoneCall($classBusiLogic,$classSpecial){
	$inEditMode = TRUE;
	if (!isset($_POST['submitForm'])) {
		$getCallType = $classSpecial->getCallType($_GET['call_type_cd']);
		$headerData = $classSpecial->getPhoneCall($_GET['id']);
		$arrSubdealerMDisp = $classBusiLogic->getSubdealerMDisp($headerData[0]['CustomerCd']);		
		include_once("./special/spl.form.PhoneCall.php");		
	}else{
		$headerData = $_POST;
		$fail_msg = $classSpecial->updatePhoneCall($headerData);

		if(!$fail_msg){
			echo '<script language="javascript"> alert("Phone Call Update Successfully!!");
			window.location.href="index.php?action=PhoneCallList";</script>';
		}
	}
}

function deletePhoneCall($classBusiLogic,$classSpecial){
	$id = $_GET['id'];
	$fail_msg = $classSpecial->deletePhoneCall($id);

		if(!$fail_msg){
			echo '<script language="javascript"> alert("Selected Phone Call Delete Successfully!!");
			window.location.href="index.php?action=PhoneCallList";</script>';
		}
	}


function highlightPhoneCall($classBusiLogic,$classSpecial){
	$id = $_GET['id'];
	$fail_msg = $classSpecial->highlightPhoneCall($id);

		if(!$fail_msg){
			echo '<script language="javascript"> alert("Selected Phone Call Highlighted Successfully!!");
			window.location.href="index.php?action=PhoneCallList";</script>';
		}
	}

function HighlightCallList($classBusiLogic,$classSpecial){
	$searchVal='';
	if (isset($_GET['searchFlag'])) {
		$searchVal = $_POST['searchVal'];		
	}	
	if(isset($_GET['SearchDate']) && $_GET['SearchDate'] !='') {
			$SearchDate = $_GET['SearchDate'];
		}else{
			$SearchDate = date('d-m-Y');
	}
	$CustomerCd ='';
	$yesterday_record = '';
	if(isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] !=''){
		$CustomerCd = $_SESSION['CustomerCd'];
		$prev_date = date("Y-m-d", strtotime("yesterday"));
		$yesterday_record = $classSpecial->ChkSummaryReport($prev_date, $CustomerCd);
		$nillReport = $classSpecial->ChkSummaryReport(date("Y-m-d"), $CustomerCd,'Nil Record');
	}
	
	$listData = $classSpecial->getHighlightPhoneCallList($SearchDate, $CustomerCd, $searchVal);
	$count = count($listData);
	$url = "DTS=".$SearchDate."&DTE=".$SearchDate;
	include_once("./special/spl.HighlightPhoneCallList.php");
}

function reportPhoneCall($classBusiLogic, $classSpecial)
{
    if (!isset($_POST['submitForm'])) {
        $utilityName = 'reportPhoneCall';
		$arrCallType = $classSpecial->getCallType();
		$CustomerCd = '';
		if(!$_SESSION['IsCustomer']){
			$CustomerCd = $_SESSION['CustomerCd'];
			$arrCustomerMDisp = $classBusiLogic->getCustomerMDisp();
		}else{
			$CustomerCd = $_SESSION['CustomerCd'];
		}
		$arrSubdealerMDisp = $classBusiLogic->getSubdealerMDisp($CustomerCd);
        include_once("special/spl.form.ReportPara.php");
    } else {
		$CustomerCd = '';
		$IdSubdealer = '';
		$calltype = '';
		$phone_details = '';
		$where_str = '';
		$url = '';
		$phone_count = 0;
        $data   = $_POST;
        $DTS	= $data['DTS'];
        $DTE    = $data['DTE'];
		$url .= "DTS=".$DTS."&DTE=".$DTE;
		if(isset($_POST['CustomerCd']) && $_POST['CustomerCd'] !=''){
			$CustomerCd = $_POST['CustomerCd'];
			$where_str .= "AND pc.CustomerCd='".$CustomerCd."'";
			$url .= "&CustomerCd=".$CustomerCd;
		}
		if(isset($_POST['IdSubdealer']) && $_POST['IdSubdealer'] !=''){
			$IdSubdealer = $_POST['IdSubdealer'];
			$where_str .= "AND pc.SubDealerCd='".$IdSubdealer."'";
			$url .= "&SubDealerCd=".$IdSubdealer;
		}
		if(isset($_POST['call_type_cd']) && $_POST['call_type_cd'] !=''){
			$calltype = $_POST['call_type_cd'];
			$url .= "&call_type_cd=".$calltype;
		}
		$arrCallType = $classSpecial->getCallType($calltype);
		$call_type_cd_array = array();
		foreach($arrCallType as $index => $value){
			$call_type_cd_array['call_type_cd'][] = $arrCallType[$index]['call_type_cd'];
		}	
		$CallType = implode("','", $call_type_cd_array['call_type_cd']);
		$phone_details = $classSpecial->reportPhoneCall($DTS, $DTE, $CallType, $where_str);

        $DTSAnsi = $classBusiLogic->convertDate($DTS, TRUE, 1);
        $DTEAnsi = $classBusiLogic->convertDate($DTE, TRUE, 1);       
        include_once("./special/spl.rep.PhoneCall.php");
    }
}



function reportSummaryPhoneCall($classBusiLogic,$classSpecial){
	if (!isset($_POST['submitForm'])) {
        $utilityName = 'reportSummaryPhoneCall';
		$arrCallType = $classSpecial->getCallType();
		$CustomerCd = '';
		if(!$_SESSION['IsCustomer']){
			$CustomerCd = $_SESSION['CustomerCd'];
			$arrCustomerMDisp = $classBusiLogic->getCustomerMDisp();
		}else{
			$CustomerCd = $_SESSION['CustomerCd'];
		}
		$arrSubdealerMDisp = $classBusiLogic->getSubdealerMDisp($CustomerCd);
        include_once("special/spl.form.ReportPara.php");
    } else {
		$url='';
		$CustomerCd = '';
		$IdSubdealer = '';
		$phone_details = '';
		$where_str = '';
		$phone_count = 0;
        $data   = $_POST;
        $DTS	= $data['DTS'];
        $DTE    = $data['DTE'];
        $CustomerCd    = $data['CustomerCd'];
		$url .= "CustomerCd=".$CustomerCd."&DTS=".$DTS."&DTE=".$DTE;
		$nodays=(strtotime($DTE) - strtotime($DTS))/ (60 * 60 * 24); //it will count no. of days
		$nodays=$nodays+1;
		$StartDate =$DTS;
		$SearchDate='';
		if(isset($_POST['CustomerCd']) && $_POST['CustomerCd'] !=''){
			$CustomerCd = $_POST['CustomerCd'];
			$where_str .= "AND pc.CustomerCd='".$CustomerCd."'";
		}
		$listData = $classSpecial->getPhoneUserList($CustomerCd);
		$count = count($listData);
	include_once("./special/spl.rep.SummaryPhCall.php");
}
}

function FillReason($classBusiLogic,$classSpecial){
	$CustomerCd = '';

	if (!isset($_POST['submitForm'])) {
		if(isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] !=''){
			$CustomerCd = $_SESSION['CustomerCd'];
		}
		$prev_date = date("Y-m-d", strtotime("yesterday")).' '.date('H:i:s');
		include_once("./special/spl.form.FillReason.php");
	}else{
		if($_GET['subAction'] == 1 && $_SESSION['CustomerCd'] !=''){
			$headerData = array('CustomerCd'=> $_SESSION['CustomerCd'], 'reason'=> 'Nill Report Submit', 'DTS'=>date('Y-m-d'), 'NilFlag' => 'on');
		}else{
			$headerData = $_POST;
		}
	
		$fail_msg = $classSpecial->insertFillPhReason($headerData);
		if(!$fail_msg){
			echo '<script language="javascript">window.location.href="index.php?action=PhoneCallList";</script>';
		}

	}

}

// Subdealer Stock -----------------------------------------------------------------------------------------------------------------------------------------

 function viewSubdealerStock($classBusiLogic, $classSpecial)
 {
	 $searchVal = isset($_POST['searchVal']) ? $_POST['searchVal'] : NULL;
	 $searchStr = '';

	 if($searchVal != ''){
		 $searchStr = " AND (E.Descript LIKE '%".$searchVal."%' OR C.Descript LIKE '%".$searchVal."%') ";
	 }
	 $IdSubdealer = '';
	 $CustomerCd = '';
	 if($_SESSION['SubdealerCd'] !=''){
		 $IdSubdealer = $_SESSION['SubdealerCd'];
	 }

	 if($_SESSION['CustomerCd'] !=''){
		 $CustomerCd = $_SESSION['CustomerCd'];
	 }
	 $StockForMY = isset($_POST['StockForMY']) ? $_POST['StockForMY'] : date('m-Y');
	 $listData = $classSpecial->getSubDealerStock($StockForMY, $searchStr, $IdSubdealer, $CustomerCd);
	 include_once("./special/spl.SubdealerStock.list.php");
 }

 function createSubDealerStock($classBusiLogic, $classSpecial)
 {
	 $IdSubdealer = '';
	 $CustomerCd = '';
	 $inEditMode = FALSE;
	 $StatusCd = "U";
	 if($_SESSION['SubdealerCd'] !=''){
		 $IdSubdealer = $_SESSION['SubdealerCd'];
	 }

	 if($_SESSION['CustomerCd'] !=''){
		 $CustomerCd = $_SESSION['CustomerCd'];
	 }
	
	 if (!isset($_POST['submitForm'])) {
		 $arrSubDealerItemMDisp	= $classSpecial->getSubDealerItemMDisp($IdSubdealer);
		 $arrSubDealerCustomerMDisp	= $classSpecial->getSubDealerCustomerMDisp($IdSubdealer);
		 $CustomerArray = $classBusiLogic->fillMasterDropDown('CustomerCd', $arrSubDealerCustomerMDisp, '',$CustomerCd, 'Customer');
		 $ItemArray = $classBusiLogic->fillMasterDropDown('ItemCd', $arrSubDealerItemMDisp, '','');
		 $headerData[0] = array("Subdealer" =>$_SESSION['SubDelaer']); 

		// echo $arrSubDealerItemMDisp;
		 include_once("./special/spl.form.SubDealerStock.php");
		 

	 }else{
		 $header = $_POST;
		 $failMsg = $classSpecial->insertSubDealerStock($header);
		 if (!$failMsg) {
			 echo "<script language='javascript'>window.location.href='index.php?action=viewSubdealerStock';</script>";
		 }
	 }
 }

 function editSubDealerStock($classBusiLogic, $classSpecial){
	 $inEditMode = TRUE;
	 $IdSubdealer  = '';
	 $CustomerCd  = '';
	 $searchVal = "";
	 $Id  = '';
	 if (!isset($_POST['submitForm'])) {
		 if(isset($_SESSION['SubdealerCd']) && $_SESSION['SubdealerCd'] !=''){
			 $IdSubdealer  = $_SESSION['SubdealerCd'];
		 }
		 if(isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] !=''){
			 $CustomerCd  = $_SESSION['CustomerCd'];
		 }		 
		 if(isset($_GET['Id']) && $_GET['Id'] !=''){
			 $Id  = $_GET['Id'];
			 $searchVal = "A.Id=".$Id;
		 }
		$ItemArr = array();
		$StockArr = array();
		$SrNo = 0;
	
		 $listData = $classSpecial->getSubDealerStockDetails($searchVal, $IdSubdealer, $CustomerCd);
		 foreach($listData AS $index => $value){
			 $ItemArr[$listData[$index]['ItemCd']] = $listData[$index]['Item'];
			 $StockArr[$listData[$index]['ItemCd']][] = $listData[$index];
		 }	
	
		 include_once("./special/spl.form.SubDealerStock.php");
	}else{
		$header = $_POST;
		
		$failMsg = $classSpecial->updateSubDealerStock($header);
		 if (!$failMsg) {
			 echo "<script language='javascript'>window.location.href='index.php?action=viewSubdealerStock';</script>";
		 }
	}

 }

 function deleteSubDealerStock($classBusiLogic, $classSpecial) {
	checkAccessLevel();
	if (isset($_GET['id'])) {		
		$failMsg = $classSpecial->deleteSubDealerStock($_GET, TRUE);
		$failMsg = '';
		afterUpdate($failMsg, "viewSubdealerStock");
	}
 }

 function approveSubDealerStock($classSpecial) {

	checkAccessLevel();
	if (isset($_GET['act'])) {
		$condTarget = $_GET['act'];
		$failMsg = $classSpecial->approveSubDealerStock($condTarget, TRUE);
		$failMsg = '';
		afterUpdate($failMsg, "viewSubdealerStock");
	}
}

function reportSubdealerStock($classBusiLogic, $classSpecial){
	 if (!isset($_POST['submitForm'])) {		
		 $utilityName = 'reportSubdealerStock';
		 $CustomerCd = '';
		 if($_SESSION['CustomerCd']){
			 $CustomerCd = $_SESSION['CustomerCd'];
		 }
		 $arrSubdealerMDisp	= $classBusiLogic->getSubdealerMDisp($CustomerCd);
		 include_once("./special/spl.form.ReportPara.php");
	 }else {
		$IdSubdealer = '';
		$CustomerCd = '';
		$url  = '';
		$data = $_POST;	
		$DTS = $data['DTS'];
		$DTE = $data['DTE'];
		$url .= "DTS =".$DTS."&DTE=".$DTE;
		$DTSAnsi = $classBusiLogic->convertDate($DTS, TRUE, 1);
		$DTEAnsi = $classBusiLogic->convertDate($DTE, TRUE, 1);
		if(isset($data['IdSubdealer']) && $data['IdSubdealer'] !=''){
			 $IdSubdealer  = $data['IdSubdealer'];
			 $url .= "&IdSubdealer=".$IdSubdealer;			
		}

		if(isset($data['CustomerCd']) && $data['CustomerCd'] !=''){
			 $CustomerCd = $data['CustomerCd'];
			 $url .= "&CustomerCd=".$CustomerCd;
		}

		if($_SESSION['CustomerCd'] || $_SESSION['IsAdmin'] || $_SESSION['IsSubAdmin']){
			$url .= "&repTyp=1";
		}
		if($_SESSION['IsSubDealer'] || $_SESSION['IsAdmin'] || $_SESSION['IsSubAdmin']){
			$url .= "&repTyp=0";
		}
	
		$searchVal = " A.DateAdded >= '".$DTSAnsi." 00:00:00' AND A.DateAdded <= '".$DTEAnsi." 59:59:59' ";
		
		$ItemArr = array();
		$StockArr = array();
		$SrNo = 0;

		$listData = $classSpecial->reportSubDealerStock($searchVal, $IdSubdealer, $CustomerCd);
		if($listData){
			foreach($listData AS $index => $value){
				$ItemArr[$listData[$index]['ItemCd']] = $listData[$index]['Item'];
				$StockArr[$listData[$index]['ItemCd']][] = $listData[$index];
			}
		}
		include_once("./special/spl.rep.SubdealerStock.php");
	 }
}


//RE11 functionality & Report
function RE11List($classBusiLogic,$classSpecial){
	$searchVal='';
	$style = '';
	$arrCompanyMDisp	= $classBusiLogic->getCompanyMDisp();
	$curDate = date('Y-m-d');
	if (isset($_GET['searchFlag'])) {
		$searchVal = $_POST['searchVal'];		
	}	
	
	$CustomerCd ='';	
	$CompanyCd ='';
	if(isset($_GET['CompanyCd']) && $_GET['CompanyCd'] !=''){
		$CompanyCd = $_GET['CompanyCd'];
	}
	if(isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] !=''){
		$CustomerCd = $_SESSION['CustomerCd'];
	}	
	$listData = $classSpecial->getRE11List($CustomerCd, $CompanyCd, $searchVal);

	$count = count($listData);

	include_once("./special/spl.RE11List.php");
}

function createRE11($classBusiLogic,$classSpecial){
	$inEditMode = false;
	if (!isset($_POST['submitForm'])) {
		$CustomerCd = '';
		$arrLicDocKey = array();
		if(isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] !=''){
			$CustomerCd = $_SESSION['CustomerCd'];
			$arrLicDocKey = $classSpecial->getLicDocKeyOfCustomer($_SESSION);
		}else{
			$arrCustomerMDisp = $classBusiLogic->getCustomerMDisp();
		}
		$arrCompanyMDisp = $classBusiLogic->getCompanyMDisp();
		$arrItemMDisp = $classBusiLogic->getItemMDisp();
		include_once("./special/spl.form.RE11.php");		
	}else{
		$headerData = $_POST;

		$fail_msg = $classSpecial->insertRE11($headerData);
		if(!$fail_msg){
			echo '<script language="javascript"> alert("RE11 Details Created Successfully!!");
			window.location.href="index.php?action=RE11List";</script>';
		}
	}	
}

function editRE11($classBusiLogic,$classSpecial){
	$inEditMode = TRUE;
	$curDate = date('Y-m-d');
	if (!isset($_POST['submitForm'])) {
		$CustomerCd = '';
		if(isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] !=''){
			$CustomerCd = $_SESSION['CustomerCd'];
		}else{
			$arrCustomerMDisp = $classBusiLogic->getCustomerMDisp();
		}
		$arrCompanyMDisp = $classBusiLogic->getCompanyMDisp();
		$arrItemMDisp = $classBusiLogic->getItemMDisp();
		$headerData = $classSpecial->getRE11($_GET['Id']);
		$arrLicDocKey = $classSpecial->getLicDocKeyOfCustomer($headerData[0]);
	
		include_once("./special/spl.form.RE11.php");		
	}else{
		$headerData = $_POST;
		$fail_msg = $classSpecial->updateRE11($headerData);

		if(!$fail_msg){
			echo '<script language="javascript"> alert("RE11 Details Update Successfully!!");
			window.location.href="index.php?action=RE11List";</script>';
		}
	}
}

function deleteRE11($classBusiLogic,$classSpecial){
	$id = $_GET['Id'];
	$fail_msg = $classSpecial->deleteRE11List($id);

		if(!$fail_msg){
			echo '<script language="javascript"> alert("Selected RE11 Delete Successfully!!");
			window.location.href="index.php?action=RE11List";</script>';
		}
	}

function reportRE11($classBusiLogic, $classSpecial)
{
    if (!isset($_POST['submitForm'])) {
		$utilityName = 'reportRE11';
		$CustomerCd = '';
		
		if(isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] !=''){
			$CustomerCd = $_SESSION['CustomerCd'];
		}else{
			$arrCustomerMDisp = $classBusiLogic->getCustomerMDisp();
		}

		$arrCompanyMDisp = $classBusiLogic->getCompanyMDisp();
		include_once("special/spl.form.ReportPara.php");
    } else {
		$CustomerCd = '';
		$RE11Details = '';		
		$url = '';
		$SrNo	 = 0;
        $data   = $_POST;
        $DTS	= $data['DTS'];
        $DTE    = $data['DTE'];
        $CompanyCd    = $data['CompanyCd'];
		$url .= "DTS=".$DTS."&DTE=".$DTE."&CompanyCd=".$CompanyCd;
		if(isset($_POST['CustomerCd']) && $_POST['CustomerCd'] !=''){
			$CustomerCd = $_POST['CustomerCd'];			
			$url .= "&CustomerCd=".$CustomerCd;
		}
		$DTSAnsi = $classBusiLogic->convertDate($DTS, TRUE, 1);
        $DTEAnsi = $classBusiLogic->convertDate($DTE, TRUE, 1); 
		
		$RE11Details = $classSpecial->reportRE11($DTSAnsi, $DTEAnsi, $CompanyCd, $CustomerCd);
              
        include_once("./special/spl.rep.re11.php");
    }
}

function ProfileList($classBusiLogic, $classSpecial){
	$Company = '';
	$CustomerCd ='(SAP Code)';

	if(isset($_GET['Company']) && $_GET['Company'] !=''){
		$Company = $_GET['Company'];
	}	
			
	if(isset($_SESSION['CustomerCd']) && $_SESSION['CustomerCd'] !=''){
		$CustomerCd = $_SESSION['CustomerCd'];
	}

	include_once("./special/spl.ProfileList.php");
}
/*EOF special functions define here by Solar IT*/
?>