File: /home/barbeatleanalyti/public_html/barisnew.beatleanalytics.com/ajax/news.php
<?php
// Include common files.
error_reporting(0);
include_once("../site/include/config_ajax.php");
include_once(INCLUDE_PATH."/dbClass.php");
$objDB = new MySQLCN();
include_once(INCLUDE_PATH."/functions.php");
include_once(INCLUDE_PATH."/storeconfig.php");
$storeconfig = new storeconfig();
include_once(TEMPLATE_PATH."/common_include.php");
// Create a new object for MySQLCN
$objDB->ClientID = FetchClientID();
define("_IMAGEPATH_",SERVERROOT_IMAGE."theme/".SITE_THEME."/images");
// Check if data is variable is exists or not into query string or post data.
if(isset($_REQUEST['data'])){
//echo "<pre>";
// Decode into base64.
$data = urldecode(base64_decode($_REQUEST['data']));
// Convert string to array of a data.
$DataExplode = explode("&",$data);
// print_r($DataExplode);
foreach($DataExplode as $key=>$val){
for($i=0; $i<count($DataExplode); $i++ ){
$DataExpSub = explode("=",$DataExplode[$i]);
if(preg_match('/acn=/',$DataExplode[$i])){
$acn = $DataExpSub[1];
}else if(preg_match('/pg=/',$DataExplode[$i])){
$pg = $DataExpSub[1];
}else if(preg_match('/val1/',$DataExplode[$i])){
$val1 = $DataExpSub[1];
}else if(preg_match('/empid=/',$DataExplode[$i])){
$empid = $DataExpSub[1];
}else if(preg_match('/v=/',$DataExplode[$i])){
$v = $DataExpSub[1];
}else if(preg_match('/s=/',$DataExplode[$i])){
$s = $DataExpSub[1];
}else if(preg_match('/SelectedValue=/',$DataExplode[$i])){
$SelectedValue = $DataExpSub[1];
}else if(preg_match('/StartDate=/',$DataExplode[$i])){
$StartDate = $DataExpSub[1];
}else if(preg_match('/EndDate=/',$DataExplode[$i])){
$EndDate = $DataExpSub[1];
}else if(preg_match('/Number=/',$DataExplode[$i])){
$Number = $DataExpSub[1];
}else if(preg_match('/AdPage=/',$DataExplode[$i])){
$AdPage = $DataExpSub[1];
}else if(preg_match('/BoxLeft=/',$DataExplode[$i])){
$BoxLeft = $DataExpSub[1];
}else if(preg_match('/BoxRight=/',$DataExplode[$i])){
$BoxRight = $DataExpSub[1];
}else if(preg_match('/BoxBottom=/',$DataExplode[$i])){
$BoxBottom = $DataExpSub[1];
}else if(preg_match('/HName=/',$DataExplode[$i])){
$HName = $DataExpSub[1];
}else if(preg_match('/HDate=/',$DataExplode[$i])){
$HDate = $DataExpSub[1];
}else if(preg_match('/HYear=/',$DataExplode[$i])){
$HYear = $DataExpSub[1];
}else if(preg_match('/HID=/',$DataExplode[$i])){
$HID = $DataExpSub[1];
}else if(preg_match('/IsActive=/',$DataExplode[$i])){
$IsActive = $DataExpSub[1];
}else if(preg_match('/EmpID=/',$DataExplode[$i])){
$EmpID = $DataExpSub[1];
}else if(preg_match('/TicketID=/',$DataExplode[$i])){
$TicketID = $DataExpSub[1];
}else if(preg_match('/RatingStar=/',$DataExplode[$i])){
$RatingStar = $DataExpSub[1];
}else if(preg_match('/RatingTicketMessageID=/',$DataExplode[$i])){
$RatingTicketMessageID = $DataExpSub[1];
}
}
}
if($acn == 'FetchEmpInOutReport'){
$Month = $SelectedValue;
$Year = $Number;
$StartDate = $Year."-".$Month."-01";
$d = new DateTime($StartDate);
$EndDate = $d->format( 'Y-m-t' );
$TotalDays = $d->format( 't' );
$SQL = "SELECT * FROM employee_login WHERE Date BETWEEN '".$StartDate."' AND '".$EndDate."' AND EmployeeID = '".$empid."' ORDER BY Date ASC LIMIT 1";
$rsDataAvailable = $objDB->sql_query($SQL);
if(count($rsDataAvailable) > 0){
$DateArr = array();
$InTime = array();
$OutTime = array();
$ShiftInTime = array();
$ShiftOutTime = array();
//echo "<pre>";
//print_r($rsFeedData);
//die;
for($i=1;$i<=$TotalDays;$i++){
$FindDate = "";
$FindDate = $Year."-".$Month."-".$i;
$SQL = "";
$SQL = "SELECT * FROM employee_login WHERE Date = '".$FindDate."' AND EmployeeID = '".$empid."' ORDER BY Date ASC";
$rsFeedData = $objDB->sql_query($SQL);
$DateArr[] = date("d/m D",strtotime($FindDate));
if(count($rsFeedData) > 0){
$InTime[] = date('H.m',strtotime($rsFeedData[0]['InTime']));
$OutTime[] = date('H.m',strtotime($rsFeedData[0]['OutTime']));
$SQL_ = "";
$SQL_ = "SELECT * FROM employee_shift WHERE ClientID = '".$objDB->ClientID."' AND ShiftID = '".$rsFeedData[0]['ShiftID']."'";
$rsShift = $objDB->sql_query($SQL_);
$ShiftInTime[] = str_replace(':',".",$rsShift[0]['StartFrom']);
$ShiftOutTime[] = str_replace(':',".",$rsShift[0]['EndTo']);
}else{
$InTime[] = "0";
$OutTime[] = "0";
$ShiftInTime[] = "0";
$ShiftOutTime[]= "0";
}
}
$rsUser = FetchUserDetails($empid,'employee');
$rsUtype = FetchUserUniqueID($empid,'employee');
$EmpArr[] = $rsUser;
$EmpArr[] = $rsUtype;
$ReturnArr = array();
$ReturnArr[0] = "Y";
$ReturnArr[1] = $InTime;
$ReturnArr[2] = $OutTime;
$ReturnArr[3] = $ShiftInTime;
$ReturnArr[4] = $ShiftOutTime;
$ReturnArr[5] = $EmpArr;
$ReturnArr[6] = $DateArr;
}else{
$ReturnArr[0] = "N";
}
echo json_encode($ReturnArr);
exit;
// print_r($DateArr); echo "<br>";
// print_r($InTime);echo "<br>";
// print_r($OutTime);echo "<br>";
// print_r($ShiftInTime);echo "<br>";
// print_r($ShiftOutTime);echo "<br>";
// die;
}else if($acn == 'FetchTicketChartData'){
if($SelectedValue != ""){
$DateArr = explode('-',str_replace(""," ",$SelectedValue));
$StartDate = date('Y-m-d',strtotime(str_replace("/","-",$DateArr[0])))." 00:00:00";
$EndDate = date('Y-m-d',strtotime(str_replace("/","-",$DateArr[1])))." 23:59:59";
$dStart = new DateTime($StartDate);
$dEnd = new DateTime($EndDate);
$DateDif = $dStart->diff($dEnd);
$DateDif = $DateDif->days;
}else{
$EndDate = date('Y-m-d H:i:s');
$DateDif = 7;
$Sday = date('d')-$DateDif;
$SMonth = date('m');
$SYear = date('Y');
$EndDate = date("Y-m-d H:i:s");
$StartDate = $SYear."-".$SMonth."-".$Sday." 00:00:00";
}
$DateArr = array();
$ResoveArr = array();
$NewTicketArr = array();
$OpenTicketArr = array();
$DueTicketArr = array();
for($i=0;$i<=$DateDif;$i++){
$date = strtotime("+".($i)." days", strtotime($StartDate));
$date = date("Y-m-d", $date);
$SQL = "SELECT COUNT(TicketID) AS RESOVE FROM ticket_master WHERE ClientID = '".$objDB->ClientID."' AND CloseDate= '".$date."' AND IsClose = 'Y' ORDER BY AddedDate ASC";
$rsRecord = $objDB->sql_query($SQL);
$SQL1 = "SELECT COUNT(TicketID) AS NewTicket FROM ticket_master WHERE ClientID = '".$objDB->ClientID."' AND AddedDate = '".$date."' ORDER BY AddedDate ASC";
$rsNewTicket = $objDB->sql_query($SQL1);
$SQL_ = "SELECT TicketID, AddedDate, IsClose FROM ticket_master
WHERE AddedDate BETWEEN (SELECT MIN( AddedDate ) FROM ticket_master WHERE ClientID = '".$objDB->ClientID."')
AND '".$date."' AND IsClose = 'N' ORDER BY AddedDate ASC";
$rsTotalTicket = $objDB->sql_query($SQL_);
$SQL2 = "SELECT TicketID, AddedDate, StartDate, EndDate, IsClose FROM ticket_master
WHERE EndDate BETWEEN (SELECT MIN( EndDate ) FROM ticket_master WHERE ClientID = '".$objDB->ClientID."')
AND '".$date."' AND IsClose = 'N' ORDER BY AddedDate ASC";
$rsDueData = $objDB->sql_query($SQL2);
$due = 0;
for($d=0;$d<count($rsDueData);$d++){
if($rsDueData[$d]['StartDate'] != "" && $rsDueData[$d]['StartDate'] != "0000-00-00 00:00:00" && $rsDueData[$d]['EndDate'] != "0000-00-00 00:00:00" && $rsDueData[$d]['StartDate'] != "" ){
if(strtotime($rsDueData[$d]['StartDate']) < strtotime($date." 00:00:00") && strtotime($rsDueData[$d]['EndDate']) < strtotime($date." 00:00:00")){
// $rsDueData[$d]['TicketID'].">>>".$rsDueData[$d]['EndDate'];
//die;
$due = $due+1;
}
}
}
$DateArr[] = date('d-m-Y',strtotime($date));
$ResoveArr[] = $rsRecord[0]['RESOVE'];
$NewTicketArr[] = $rsNewTicket[0]['NewTicket'];
$OpenTicketArr[] = count($rsTotalTicket);
$DueTicketArr[] = $due;
}
$ReturnArr[0] = $DateArr;
$ReturnArr[1] = $ResoveArr;
$ReturnArr[2] = $NewTicketArr;
$ReturnArr[3] = $OpenTicketArr;
$ReturnArr[4] = $DueTicketArr;
$ReturnArr[5][0] = date("d-m-Y",strtotime($StartDate));
$ReturnArr[5][1] = date("d-m-Y",strtotime($EndDate));
//echo "<pre>";
//print_r($ReturnArr);
//die;
echo json_encode($ReturnArr);
}else if($acn == 'FetchProjectChartTicket'){
$SQL = "SELECT * FROM project_master WHERE ClientID = '".$objDB->ClientID."' AND ProjStatus NOT IN('close')";
$rsProject = $objDB->sql_query($SQL);
$ProjectArr = array();
if(count($rsProject) > 0){
for($i=0;$i<count($rsProject);$i++){
$SQL_ = "SELECT * FROM ticket_master WHERE ClientID = '".$objDB->ClientID."' AND IsReletedToProject = 'Y' AND ProjectID = '".$rsProject[$i]['ProjectID']."' AND IsClose = 'Y' ";
$rsTicketInfo = $objDB->sql_query($SQL_);
$SQL1 = "SELECT * FROM ticket_master WHERE ClientID = '".$objDB->ClientID."' AND IsReletedToProject = 'Y' AND ProjectID = '".$rsProject[$i]['ProjectID']."' AND IsClose = 'N' ";
$rsTicketInfo1 = $objDB->sql_query($SQL1);
if(count($rsTicketInfo) > 0 || count($rsTicketInfo1) > 0){
$ProjectArr[] = $rsProject[$i]['Name'];
$TicketCloseArr[] = count($rsTicketInfo);
$TicketRunningArr[] = count($rsTicketInfo1);
$TicketTotalArr[] = (count($rsTicketInfo) + count($rsTicketInfo1));
}
}
$ReturnArr[0] = $ProjectArr;
$ReturnArr[1] = $TicketRunningArr;
$ReturnArr[2] = $TicketCloseArr;
$ReturnArr[3] = $TicketTotalArr;
}else{
$ReturnArr[0] = "N";
$ReturnArr[1] = "No any running project found";
}
echo json_encode($ReturnArr);
exit;
}else if($acn == 'FetchEmployeeLeaveReport'){
$SQL_e = "SELECT WeeklyOffDay, IsDefaultWeeklyOffDay, FirstName, MiddleName, SurName FROM employee WHERE EmployeeID = '".$empid."' AND ClientID = '".$objDB->ClientID."'";
$rsEmpData = $objDB->sql_query($SQL_e);
$OffDays = $rsEmpData[0]['WeeklyOffDay'];
if(strtolower($rsEmpData[0]['IsDefaultWeeklyOffDay']) == 'y'){
$SQL_d = "SELECT WeeklyOff AS OffDays FROM client_master WHERE ClientID = '".$objDB->ClientID."'";
$rsDefault = $objDB->sql_query($SQL_d);
$OffDays = $rsEmpData[0]['WeeklyOffDay'];
}
$WeeklyOff = explode(",",$OffDays);
//$SelectedValue = '01/04/2016-31/04/2016';
//$WeeklyOff = array("Sun");
$LeaveArr = array();
if($SelectedValue != ""){
$DateArr = explode('-',str_replace(""," ",$SelectedValue));
$StartDate = date('Y-m-d',strtotime(str_replace("/","-",$DateArr[0])));
$EndDate = date('Y-m-d',strtotime(str_replace("/","-",$DateArr[1])));
}else{
$StartDate = date('Y')."-".date('m')."-01";
$EndDate = date('Y-m-d');
}
$dStart = new DateTime($StartDate);
$dEnd = new DateTime($EndDate);
$DateDif = $dStart->diff($dEnd);
$DateDif = $DateDif->days;
for($i=0;$i<=$DateDif;$i++){
$date = strtotime("+".($i)." days", strtotime($StartDate));
$date = date("Y-m-d", $date);
$SQL = "SELECT EmployeeID FROM employee_login WHERE Date = '".$date."' AND EmployeeID = '".$empid."' AND ClientID = '".$objDB->ClientID."' ORDER BY Date ASC LIMIT 1";
$rsLoginData = $objDB->sql_query($SQL);
if(count($rsLoginData) > 0){
$PresentDayArr[] = $date;
}else{
$SQL_ = "SELECT * FROM leave_details WHERE ClientID = '".$objDB->ClientID."' AND UserID = '".$empid."'
AND LeaveMonth = '".date('m',strtotime($date))."' AND LeaveYear = '".date('Y',strtotime($date))."'";
$rsLeave = $objDB->sql_query($SQL_);
if(count($rsLeave) > 0){
for($l=0;$l<count($rsLeave);$l++){
$lStart = new DateTime($rsLeave[$l]['LeaveStart']);
$lEnd = new DateTime($rsLeave[$l]['LeaveEnd']);
$LDateDif = $lStart->diff($lEnd);
$LDateDif = $LDateDif->days;
//if($LDateDif > 0){
for($le=0;$le<=$LDateDif;$le++){
$Day = "";
$Day = date('D',strtotime($date));
$Newdate = strtotime("+".($le)." days", strtotime($rsLeave[$l]['LeaveStart']));
$Newdate = date("Y-m-d", $Newdate);
if(strtotime($date) == strtotime($Newdate) && !in_array($Day,$WeeklyOff) && !in_array($date,$PLArr) && !in_array($date,$SLArr) && !in_array($date,$CLArr) ){
if($rsLeave[$l]['LeaveType'] == 'PL' && FetchAppconfigStatus('YEARLY_PL') == 'Y'){
$PLArr[] = $date;
}else if($rsLeave[$l]['LeaveType'] == 'SL' && FetchAppconfigStatus('YEARLY_SL') == 'Y'){
$SLArr[] = $date;
}else if($rsLeave[$l]['LeaveType'] == 'CL' && FetchAppconfigStatus('YEARLY_CL') == 'Y'){
$CLArr[] = $date;
}else{
$OtherLeaveArr[] = $date;
}
}else if(!in_array($date,$OtherLeaveArr) && !in_array($date,$PLArr) && !in_array($date,$SLArr) && !in_array($date,$CLArr) ){
$OtherLeaveArr[] = $date;
}
}
}
}else{
$Day = "";
$Day = date('D',strtotime($date));
$OtherLeaveArr[] = $date;
}
}
}
$ReturnArr = array();
$NotCountedLeave = count($OtherLeaveArr);
$ReturnArr[0] = 'Y';
if(count($PLArr) <= 0 && count($SLArr) <= 0 && count($CLArr) <= 0 && count($OtherLeaveArr) <= 0 && count($PresentDayArr) <= 0){
$ReturnArr[0] = 'N';
}
if(FetchAppconfigStatus('YEARLY_PL') == 'Y'){
$NotCountedLeave = $NotCountedLeave - count($PLArr);
$LeaveArr[] = count($PLArr);
$LeaveArrTitle[]= 'PL'; // Yellow >> PL
$LeaveColor[] = '#FDB45C';
}
if(FetchAppconfigStatus('YEARLY_SL') == 'Y'){
$NotCountedLeave = $NotCountedLeave - count($SLArr);
$LeaveArr[] = count($SLArr);
$LeaveArrTitle[]= 'SL'; // Grey >> SL
$LeaveColor[] = '#949FB1';
}
if(FetchAppconfigStatus('YEARLY_CL') == 'Y'){
$NotCountedLeave = $NotCountedLeave - count($CLArr);
$LeaveArr[] = count($CLArr);
$LeaveArrTitle[]= 'CL'; // Red >> CL
$LeaveColor[] = '#F7464A';
}
$LeaveArrTitle[]= 'No Counted';
$LeaveColor[] = '#4D5360'; // Gray No Counted
$LeaveArr[] = $NotCountedLeave;
$LeaveArrTitle[]= 'Present Days';
$LeaveColor[] = '#46BFBD'; // Green >> Present Day
$LeaveArr[] = count($PresentDayArr);
$ReturnArr[1][0] = $LeaveArr;
$ReturnArr[1][1] = $LeaveArrTitle;
$ReturnArr[1][2] = $LeaveColor;
$ReturnArr[2][0] = date("d-m-Y",strtotime($StartDate));
$ReturnArr[2][1] = date("d-m-Y",strtotime($EndDate));
echo json_encode($ReturnArr);
exit;
}else if($acn == 'FetchEmployeeCurrentLoginChart'){
if($SelectedValue == ""){
$SelectedValue = date("Y-m-d");
}else{
$SelectedValue = date("Y-m-d",strtotime($SelectedValue));
}
$SQL_e = "SELECT EmployeeID FROM employee WHERE IsActive = 'Y' AND (IsResignApproved IS NULL OR IsResignApproved = 'N') AND ClientID = '".$objDB->ClientID."'" ;
$rsEmployee = $objDB->sql_query($SQL_e);
if(count($rsEmployee) > 0){
$SQL = "SELECT E.FirstName, E.MiddleName, E.SurName, E.EmployeeID, EL.Date FROM employee_login AS EL INNER JOIN employee AS E ON E.EmployeeID = EL.EmployeeID WHERE Date = '".$SelectedValue."' AND E.ClientID = '".$objDB->ClientID."'" ;
$rsLogedIn = $objDB->sql_query($SQL);
$ReturnArr = array();
$ReturnArr[0] = count($rsLogedIn); // Login Employee
$ReturnArr[1] = count($rsEmployee) - count($rsLogedIn); // Not Login
$ReturnArr[2] = count($rsEmployee); // Total Employee
$ReturnArr[3] = date('d F Y, l',strtotime($SelectedValue)); // Total Employee
}else{
$ReturnArr[0] = "N";
$ReturnArr[1] = "No any employee found..";
}
echo json_encode($ReturnArr);
exit;
}else if($acn == 'FetchSalaryCalculationChart'){
$GrossSalary =array();
$CTCSalary =array();
$TotalDeduction =array();
$NetSalary =array();
$EmployerContSal =array();
$SalaryComArr = array("GrossSalary","CTCSalary","TotalDeduction","NetSalary","EmployerContSal");
$SalError = 0;
$SalMsg = "Successfully Complited";
if($val1 == 'M'){
//$EndDate = "09-2016";
$StartArr = explode('-',$StartDate);
$EndArr = explode('-',$EndDate);
$StartMonth = $StartArr[0];
$EndMonth = $EndArr[0];
$StartYear = $StartArr[1];
$EndYear = $EndArr[1];
if(($StartYear > $EndYear) || ($StartMonth > $EndMonth && ($StartYear == $EndYear))){
$SalError = 1;
$SalMsg = "Ooops..! Start month or end month is not valid..";
}
$StartDuration = date('F Y',strtotime($StartYear."-".$StartMonth));
$EndDuration = date('F Y',strtotime($EndYear."-".$EndMonth));
if($SalError != 1){
for($Y=$StartYear;$Y<=$EndYear;$Y++){
for($M=$StartMonth;$M<=12;$M++){
if($M > $EndMonth && $Y == $EndYear){
break;
}else{
//$MonthArr[] = $M;
foreach($SalaryComArr as $key=>$field){
$SQL = "";
$SQL = "SELECT SUM(".$field.") AS ".$field." FROM employee_payroll WHERE SalaryYear = '".$Y."' AND SalaryMonth = '".$M."' AND ClientID = '".$objDB->ClientID."' ";
$rsPayroll = $objDB->sql_query($SQL);
$RecordData[$field][] = $rsPayroll[0][$field];
}
$YearArr[] = date('F Y',strtotime($Y."-".$M));
}
}
}
}
}else{
if($SelectedValue == "" || $SelectedValue == "null"){
$SalError = 1;
$SalMsg = "Ooops..! Please select at list one salary year..";
}
$FindYear = explode(',',$SelectedValue);
$StartDuration = $FindYear[0];
$EndDuration = end($FindYear);
foreach($FindYear as $key=>$Year){
foreach($SalaryComArr as $key=>$field){
$SQL = "";
$SQL = "SELECT SUM(".$field.") AS ".$field." FROM employee_payroll WHERE SalaryYear = '".$Year."' AND ClientID = '".$objDB->ClientID."' ";
$rsPayroll = $objDB->sql_query($SQL);
$RecordData[$field][] = $rsPayroll[0][$field];
}
$YearArr[] = $Year;
}
}
$ReturnArr[0][0] = $SalMsg;
$ReturnArr[0][1] = $SalError;
$ReturnArr[1] = $RecordData['GrossSalary'];
$ReturnArr[2] = $RecordData['CTCSalary'];
$ReturnArr[3] = $RecordData['TotalDeduction'];
$ReturnArr[4] = $RecordData['NetSalary'];
$ReturnArr[5] = $RecordData['EmployerContSal'];
$ReturnArr[6] = $YearArr;
$ReturnArr[7] = $SalaryComArr;
$ReturnArr[8][0] = $StartDuration;
$ReturnArr[8][1] = $EndDuration;
echo json_encode($ReturnArr);
exit;
}else if($acn == 'FecthIndividualSalaryExpenditure'){
$StartArr = explode('-',$StartDate);
$EndArr = explode('-',$EndDate);
$StartMonth = $StartArr[0];
$EndMonth = $EndArr[0];
$StartYear = $StartArr[1];
$EndYear = $EndArr[1];
$TotalEarningComp = array();
$TotalDeductionCompArr = array();
$TotalContributionComp = array();
$ComponentNameArr = array();
$SalError = 0;
if(($StartYear > $EndYear) || ($StartMonth > $EndMonth && ($StartYear == $EndYear))){
$SalError = 1;
$SalMsg = "Ooops..! Start month or end month is not valid..";
}
if($SalError != 1){
for($Y=$StartYear;$Y<=$EndYear;$Y++){
for($M=$StartMonth;$M<=12;$M++){
if($M > $EndMonth && $Y == $EndYear){
break;
}else{
$SQL = "";
$SQL = "SELECT GrossSalary, CTCSalary, TotalDeduction, NetSalary, EmployerContSal, EmployerContributions, Deductions, Earning FROM employee_payroll WHERE EmployeeID = '".$empid."' AND SalaryYear = '".$Y."' AND SalaryMonth = '".$M."' AND ClientID = '".$objDB->ClientID."' ORDER BY EmpPayrollID DESC ";
$rsPayroll = $objDB->sql_query($SQL);
if(count($rsPayroll) > 0){
$EarningArr = unserialize($rsPayroll[0]['Earning']);
$DeductionArr = unserialize($rsPayroll[0]['Deductions']);
$ContributionArr = unserialize($rsPayroll[0]['EmployerContributions']);
foreach($EarningArr as $SalCompo=>$Val){
if(!empty($Val)){
$CompoName = FethComponetName($SalCompo,"E");
if(in_array($CompoName,$ComponentNameArr['Earning'])){
$TotalEarningCompArr[$SalCompo] = $TotalEarningCompArr[$SalCompo] + $Val;
}else{
$ComponentNameArr['Earning'][] = $CompoName;
$TotalEarningCompArr[$SalCompo] = $Val;
}
}
}
foreach($DeductionArr as $SalCompo=>$Val){
if(!empty($Val)){
$CompoName = FethComponetName($SalCompo,"D");
if(in_array($CompoName,$ComponentNameArr['Deduction'])){
$TotalDeductionCompArr[$SalCompo] = $TotalDeductionCompArr[$SalCompo] + $Val;
}else{
$ComponentNameArr['Deduction'][] = FethComponetName($SalCompo,"D");
$TotalDeductionCompArr[$SalCompo] = $Val;
}
}
}
foreach($ContributionArr as $SalCompo=>$Val){
if(!empty($Val)){
$CompoName = FethComponetName($SalCompo,"CD");
if(in_array($CompoName,$ComponentNameArr['Contribution'])){
$TotalContributionCompArr[$SalCompo] = $TotalContributionCompArr[$SalCompo] + $Val;
}else{
$ComponentNameArr['Contribution'][] = FethComponetName($SalCompo,"CD");
$TotalContributionCompArr[$SalCompo] = $Val;
}
}
}
}
//$YearArr[] = date('F Y',strtotime($Y."-".$M));
}
}
}
}
(float)$TotalEarning = array_sum($TotalEarningCompArr);
(float)$TotalDeduction = array_sum($TotalDeductionCompArr);
(float)$TotalContribution = array_sum($TotalContributionCompArr);
if(count($TotalEarningCompArr) > 0 || count($TotalDeductionCompArr) > 0 || count($TotalContributionCompArr) > 0 && $SalError != 1){
$ResultArr[0] = 0;
$ResultArr[1][0] = array_values($ComponentNameArr['Earning']);
$ResultArr[1][1] = array_values($TotalEarningCompArr);
$ResultArr[2][0] = array_values($ComponentNameArr['Deduction']);
$ResultArr[2][1] = array_values($TotalDeductionCompArr);
$ResultArr[3][0] = array_values($ComponentNameArr['Contribution']);
$ResultArr[3][1] = array_values($TotalContributionCompArr);
$ResultArr[4][0] = array("Earning","Employee Deduction","Company Contribution");
$ResultArr[4][1] = array($TotalEarning,$TotalDeduction,$TotalContribution);
$ResultArr[5][0] = date('F Y',strtotime($StartYear."-".$StartMonth));
$ResultArr[5][1] = date('F Y',strtotime($EndYear."-".$EndMonth));
}else{
$ResultArr[0][0] = 1;
if($SalError == 1){
$ResultArr[0][1] = $SalMsg;
}else{
$ResultArr[0][1] = "No any record found..";
}
}
echo json_encode($ResultArr);
}else if($acn == 'FetchSalesReportData'){
$StartArr = explode('-',$StartDate);
$EndArr = explode('-',$EndDate);
$StartMonth = $StartArr[0];
$EndMonth = $EndArr[0];
$StartYear = $StartArr[1];
$EndYear = $EndArr[1];
$FindYear = explode(',',$SelectedValue); // User For Yearly Report
$SalError = 0;
$SalMsg = "Generated Successfully..";
if($val1 == 'Y'){
if($SelectedValue == "" || $SelectedValue == 'null' ){
$SalError = 1;
$SalMsg = "Ooops..! Please select sales years..";
}
if($SalError != 1){
foreach($FindYear as $key=>$Year){
$s_date = $Year."-01-01";
$e_date = $Year."-12-31";
$SQL = "";
$SQL = "SELECT SUM(TotalAmount) AS TotalSales FROM bill_invoice WHERE AddedDate BETWEEN '".$s_date."' AND '".$e_date."' AND ClientID = '".$objDB->ClientID."'";
$rsSales = $objDB->sql_query($SQL);
if(count($rsSales) > 0 && !empty($rsSales[0]['TotalSales'])){
$SalesArr[] = round($rsSales[0]['TotalSales']);
}else{
$SalesArr[] = 0;
}
$YearArr[] = $Year;
}
}
}else{
if(($StartYear > $EndYear) || ($StartMonth > $EndMonth && ($StartYear == $EndYear))){
$SalError = 1;
$SalMsg = "Ooops..! Start month or end month is not valid..";
}
if($SalError != 1){
for($Y=$StartYear;$Y<=$EndYear;$Y++){
for($M=$StartMonth;$M<=12;$M++){
if($M > $EndMonth && $Y == $EndYear){
break;
}else{
$s_date = $Y."-".$M."-01";
$e_date = date("Y-m-t", strtotime($s_date));
$SQL = "";
$SQL = "SELECT SUM(TotalAmount) AS TotalSales FROM bill_invoice WHERE AddedDate BETWEEN '".$s_date."' AND '".$e_date."' AND ClientID = '".$objDB->ClientID."'";
$rsSales = $objDB->sql_query($SQL);
if(count($rsSales) > 0 && !empty($rsSales[0]['TotalSales'])){
$SalesArr[] = round($rsSales[0]['TotalSales']);
}else{
$SalesArr[] = 0;
}
$YearArr[] = date('M Y',strtotime($Y."-".$M));
}
}
}
}
}
if($SalError != 1){
$ReturnArr[0][0] = $SalMsg;
$ReturnArr[0][1] = $SalError;
$ReturnArr[1] = $SalesArr;
$ReturnArr[2] = $YearArr;
$ReturnArr[3][0] = date('F Y',strtotime($EndYear."-".$StartMonth));
$ReturnArr[3][1] = date('F Y',strtotime($EndYear."-".$EndMonth));
}else{
$ReturnArr[0][0] = $SalMsg;
$ReturnArr[0][1] = $SalError;
}
echo json_encode($ReturnArr);
}else if($acn == 'FetchProfitLossReport'){
$StartArr = explode('-',$StartDate);
$EndArr = explode('-',$EndDate);
$StartMonth = $StartArr[0];
$EndMonth = $EndArr[0];
$StartYear = $StartArr[1];
$EndYear = $EndArr[1];
$FindYear = explode(',',$SelectedValue); // User For Yearly Report
$SalError = 0;
$SalMsg = "Generated Successfully..";
if($val1 == 'Y'){
if($SelectedValue == "" || $SelectedValue == 'null' ){
$SalError = 1;
$SalMsg = "Ooops..! Please select year..";
}
if($SalError != 1){
foreach($FindYear as $key=>$Year){
(float)$PurchesPrice = 0;
(float)$TotalPurches = 0;
$ProductID = "";
$s_date = $Year."-01-01";
$e_date = $Year."-12-31";
$SQL = "";
$SQL = "SELECT ProductID, Quantity FROM bill_stock_in WHERE AddedDate BETWEEN '".$s_date."' AND '".$e_date."' AND ClientID = '".$objDB->ClientID." ORDER BY ProductID'";
$rsStockIn = $objDB->sql_query($SQL);
for($i=0;$i<count($rsStockIn);$i++){
if($rsStockIn[$i]['ProductID'] != $ProductID){
$ProductID = $rsStockIn[$i]['ProductID'];
$rsProduct = FetchProductPurchesDetails($ProductID);
$TotalPurchesPrice = $rsProduct[0]['PurchasePrice'] * $rsStockIn[$i]['Quantity'];
}
$TotalPurches = $TotalPurches + $TotalPurchesPrice;
}
$SQL_ = "SELECT SUM(BIM.Total) AS TotalSales FROM bill_invoice AS BI LEFT JOIN bill_invoice_product_mapping AS BIM ON BI.InvoiceID = BIM.InvoiceID
WHERE BI.AddedDate BETWEEN '".$s_date."' AND '".$e_date."' AND BI.ClientID = '".$objDB->ClientID."'";
$rsSales = $objDB->sql_query($SQL_);
$TotalSalesAmount = 0;
if($rsSales[0]['TotalSales'] > 0){
$TotalSalesAmount = $rsSales[0]['TotalSales'];
}
$PurchaseArr[] = $TotalPurches;
$SalesArr[] = $TotalSalesAmount;
$ProfitArr[] = (float)($TotalSalesAmount - $TotalPurches);
$YearArr[] = $Year;
}
}
}else{
if(($StartYear > $EndYear) || ($StartMonth > $EndMonth && ($StartYear == $EndYear))){
$SalError = 1;
$SalMsg = "Ooops..! Start month or end month is not valid..";
}
if($SalError != 1){
for($Y=$StartYear;$Y<=$EndYear;$Y++){
for($M=$StartMonth;$M<=12;$M++){
if($M > $EndMonth && $Y == $EndYear){
break;
}else{
$s_date = $Y."-".$M."-01";
$e_date = date("Y-m-t", strtotime($s_date));
$SQL = "";
$SQL = "SELECT ProductID, Quantity FROM bill_stock_in WHERE AddedDate BETWEEN '".$s_date."' AND '".$e_date."' AND ClientID = '".$objDB->ClientID." ORDER BY ProductID'";
$rsStockIn = $objDB->sql_query($SQL);
for($i=0;$i<count($rsStockIn);$i++){
if($rsStockIn[$i]['ProductID'] != $ProductID){
$ProductID = $rsStockIn[$i]['ProductID'];
$rsProduct = FetchProductPurchesDetails($ProductID);
$TotalPurchesPrice = $rsProduct[0]['PurchasePrice'] * $rsStockIn[$i]['Quantity'];
}
$TotalPurches = $TotalPurches + $TotalPurchesPrice;
}
$SQL_ = "SELECT SUM(BIM.Total) AS TotalSales FROM bill_invoice AS BI LEFT JOIN bill_invoice_product_mapping AS BIM ON BI.InvoiceID = BIM.InvoiceID
WHERE BI.AddedDate BETWEEN '".$s_date."' AND '".$e_date."' AND BI.ClientID = '".$objDB->ClientID."'";
$rsSales = $objDB->sql_query($SQL_);
$TotalSalesAmount = 0;
if($rsSales[0]['TotalSales'] > 0){
$TotalSalesAmount = $rsSales[0]['TotalSales'];
}
$PurchaseArr[] = $TotalPurches;
$SalesArr[] = $TotalSalesAmount;
$ProfitArr[] = (float)($TotalSalesAmount - $TotalPurches);
$YearArr[] = date('M Y',strtotime($Y."-".$M));
}
}
}
}
}
if($val1 == 'M'){
$StartDuretion = date('F Y',strtotime($EndYear."-".$StartMonth));
$EndDuretion = date('F Y',strtotime($EndYear."-".$EndMonth));
}else{
$StartDuretion = $FindYear[0];
$EndDuretion = end($FindYear);
}
if($SalError != 1){
$ReturnArr[0][0] = $SalMsg;
$ReturnArr[0][1] = $SalError;
$ReturnArr[1][0] = $PurchaseArr;
$ReturnArr[1][1] = $SalesArr;
$ReturnArr[1][2] = $ProfitArr;
$ReturnArr[2] = $YearArr;
$ReturnArr[3][0] = $StartDuretion;
$ReturnArr[3][1] = $EndDuretion;
}else{
$ReturnArr[0][0] = $SalMsg;
$ReturnArr[0][1] = $SalError;
}
echo json_encode($ReturnArr);
}else if($acn == 'ChangeChartPosition'){
if($SelectedValue != "" && $val != ""){
$_SESSION['Setting']['ChartBox'][$SelectedValue] = $val1;
}
}else if($acn == "ChangeChartBoxPosition"){
if($BoxLeft != "" && $BoxRight != "" && $BoxBottom != ""){
$_SESSION['Setting']['ChartBoxPosition']['BoxLeft'] = $BoxLeft;
$_SESSION['Setting']['ChartBoxPosition']['BoxRight'] = $BoxRight;
$_SESSION['Setting']['ChartBoxPosition']['BoxBottom'] = $BoxBottom;
}
}else if($acn == "FetchCharBoxPosition"){
if(isset($_SESSION['Setting']['ChartBoxPosition'])){
$RetunArr[0] = 'Y';
$RetunArr[1] = explode(',',$_SESSION['Setting']['ChartBoxPosition']['BoxLeft']);
$RetunArr[2] = explode(',',$_SESSION['Setting']['ChartBoxPosition']['BoxRight']);
$RetunArr[3] = explode(',',$_SESSION['Setting']['ChartBoxPosition']['BoxBottom']);
}else{
$RetunArr[0] = 'N';
}
echo json_encode($RetunArr);
}else if($acn == "FetchNotification"){
$Subject = array();
$Message = array();
$IsLogin = 'Y';
if(!isset($_SESSION['UserInfo']) || count($_SESSION['UserInfo']) != 4 || !isset($_SESSION['UserInfo']['SessionID']) || $_SESSION['UserInfo']['SessionID'] != session_id() || $_SESSION['UserInfo']['UniqueID'] == "" || $_SESSION['UserInfo']['UType'] == "" )
{
$IsLogin = 'N';
}
$SQL = "SELECT * FROM news WHERE ( (StartDate <= '".date('Y-m-d')."' AND EndDate >= '".date('Y-m-d')."') OR IsTimeLimit = 'N')";
if($IsLogin == 'Y'){
if($_SESSION['UserInfo']['UType'] == 'MasterAdmin'){
$SQL.= " AND IsView = 'N'";
$UYype = "masteradmin";
}else{
$SQL.= " AND NewsID NOT IN(SELECT NewsID FROM news_view_log WHERE EmployeeID = '".$_SESSION['UserInfo']['UserID']."')";
$UYype = "employee";
}
}else{
$SQL.= " AND WithoutLogin = 'Y'";
}
$SQL.= " AND ( LOWER(NewsFor) = '".$UYype."' OR LOWER(NewsFor) = 'both' )";
$rsNews = $objDB->sql_query($SQL);
if(count($rsNews) > 0){
$Result = 'Y';
for($i=0;$i<count($rsNews);$i++){
$NewsID[] = $rsNews[$i]['NewsID'];
$Subject[] = $rsNews[$i]['Subject'];
$Message[] = $rsNews[$i]['Message'];
}
}else{
$Result = 'N';
}
$ReturnArr[0] = $Result;
$ReturnArr[1] = $Subject;
$ReturnArr[2] = $Message;
$ReturnArr[3] = $NewsID;
echo json_encode($ReturnArr);
}else if($acn == 'FetchOldNews'){
$SQL = "SELECT NewsID, Subject, Message FROM news WHERE NewsID = '".$val1."'";
$rsNews = $objDB->sql_query($SQL);
$ReturnArr[0] = $rsNews[0]['Subject'];
$ReturnArr[1] = $rsNews[0]['Message'];
$ReturnArr[2] = $rsNews[0]['NewsID'];
echo json_encode($ReturnArr);
}else if($acn == "UPDATENewsInfo"){
$id = explode('_',$val1);
$IsLogin = 'Y';
if(!isset($_SESSION['UserInfo']) || count($_SESSION['UserInfo']) != 4 || !isset($_SESSION['UserInfo']['SessionID']) || $_SESSION['UserInfo']['SessionID'] != session_id() || $_SESSION['UserInfo']['UniqueID'] == "" || $_SESSION['UserInfo']['UType'] == "" )
{
$IsLogin = 'N';
}
if(!empty($id[1]) && $IsLogin == 'Y'){
if($_SESSION['UserInfo']['UType'] == 'MasterAdmin'){
$SQL = "UPDATE news SET IsView = 'Y' WHERE NewsID = '".$id[1]."'";
}else{
$SQL = "INSERT INTO news_view_log SET NewsID = '".$id[1]."', EmployeeID = '".$_SESSION['UserInfo']['UserID']."', AddedDate = '".date('Y-m-d H:i:s')."'";
}
$rsUpdate = $objDB->sql_query($SQL);
}
}else if($acn == "FetchAllAdvertisement"){
$objDB = $objDB->ConnectNewDatabase(DB_USERNAME_ADMIN, DB_PASS_ADMIN, DB_SERVER_ADMIN, DB_DATABASE_ADMIN);
// Start Code FOR Main Slider And Main Ad
$SQL = "SELECT * FROM `ad_master` WHERE IsActive = 'Y' AND IsImage = 'Y' AND ( StartDate <= '".date('Y-m-d')."' AND EndDate >= '".date('Y-m-d')."' ) AND AdTypeID = '1' AND AdPage = '".$AdPage."'";
$rsAd = $objDB->sql_query($SQL);
$rsAd = array();
if(count($rsAd) <= 0){
$IsDefult = "Y";
$rsAd = array("5605311102016.jpg","109411102016.jpg");
//$DefultImageArr = array("5605311102016.jpg","109411102016.jpg");
}
$html = '';
$Result = "N";
$id = rand(0,(count($rsAd)-1));
if($IsDefult == 'Y'){
$FileName = $rsAd[$id];
$urlLocation = "http://cranemaze.com";
}else{
$FileName = $rsAd[$id]['AdImage'];
$urlLocation = $rsAd[$id]['AdURL'];
}
if(count($rsAd) > 0){
$html.= '<div id="carousel-example-generic" class="carousel slide" data-ride="carousel">
<ol class="carousel-indicators">';
// for($j=0;$j<count($rsAd);$j++){
// if($j==$id)$active = "active"; else $active = "";
//$html.= '<li data-target="#carousel-example-generic" data-slide-to="'.$id.'" class="'.$active.'"></li>';
// }
$html.= '</ol>';
$html.= '<div class="carousel-inner">';
// for($i=0;$i<count($rsAd);$i++){
$active = "active";
// if($i==$id)$active = "active"; else $active = "";
$html.= '<div class="item '.$active.'">
<a href="'.$urlLocation.'" target="_blank"><img src="'.AD_FILE_PATH.$FileName.'" alt="First slide"></a>
</div>';
//}
$html.= '</div>';
/* $html.= ' <a class="left carousel-control" href="#carousel-example-generic" data-slide="prev">
<span class="fa fa-angle-left"></span>
</a>
<a class="right carousel-control" href="#carousel-example-generic" data-slide="next">
<span class="fa fa-angle-right"></span>
</a>';
*/
$html.= '</div>';
$Result = 'Y';
}else{
$Result = 'N';
}
$ReturnArr[0][0] = $Result;
$ReturnArr[0][1] = $html;
// End Code FOR Main Slider And Main Ad
// Start Code for 300x250 Image Slider
$SQL_ = "SELECT * FROM `ad_master` WHERE IsActive = 'Y' AND IsImage = 'Y' AND ( StartDate <= '".date('Y-m-d')."' AND EndDate >= '".date('Y-m-d')."' ) AND AdTypeID = '3' AND AdPage = '".$AdPage."'";
$rsAd300 = $objDB->sql_query($SQL_);
$html = '';
$id = '';
$Result = "N";
//$id = rand(0,(count($rsAd300)-1));
if(count($rsAd300) > 0){
$id = rand(0,(count($rsAd300)-1));
$html.= '<a href="'.$rsAd300[$id]['AdURL'].'" target="_blank">
<img class="img-responsive box pad" src="'.AD_FILE_PATH.$rsAd300[$id]['AdImage'].'" alt="Photo">
</a>';
$Result = 'Y';
}else{
$Result = 'N';
}
$ReturnArr[1][0] = $Result;
$ReturnArr[1][1] = $html;
$callID = $rsAd300[$id]['AdID'];
// End Code for 300x250 Image Slider
// Start Code for 300x250 Text Slider
$SQL = "SELECT * FROM `ad_master` WHERE IsActive = 'Y' AND IsImage = 'N' AND ( StartDate <= '".date('Y-m-d')."' AND EndDate >= '".date('Y-m-d')."' ) AND AdTypeID = '4' AND AdPage = '".$AdPage."'";
$rsAd300text = $objDB->sql_query($SQL);
$html = '';
$id = '';
$Result = "N";
if($rsAd300text){
$id = rand(0,(count($rsAd300text)-1));
$html.= '<a href="'.$rsAd300text[$id]['AdURL'].'" target="_blank">
<div class="box box-widget">
<div class="box-body">'.$rsAd300text[$id]['AdContains'].'</div>
</div></a>';
$Result = 'Y';
}else{
if(count($rsAd300) > 0){
$SQL_.= " AND AdID NOT IN(".$callID.")";
$rsAd3002 = $objDB->sql_query($SQL_);
if(count($rsAd3002) > 0){
$id = "";
$id = rand(0,(count($rsAd3002)-1));
$html.= '<a href="'.$rsAd3002[$id]['AdURL'].'" target="_blank"><div class="box box-widget">
<img class="img-responsive box pad" src="'.AD_FILE_PATH.$rsAd3002[$id]['AdImage'].'" alt="Photo">
</a>';
$Result = 'Y';
}else{
$Result = 'N';
}
}
}
$ReturnArr[2][0] = $Result;
$ReturnArr[2][1] = $html;
// End Code for 300x250 Text Slider
// Start Code for 625x250 Image Slider
$SQL = "SELECT * FROM `ad_master` WHERE IsActive = 'Y' AND IsImage = 'Y' AND ( StartDate <= '".date('Y-m-d')."' AND EndDate >= '".date('Y-m-d')."' ) AND AdTypeID = '2' AND AdPage = '".$AdPage."'";
$rsAd625 = $objDB->sql_query($SQL);
$html = '';
$id = '';
$id = rand(0,(count($rsAd625)-1));
if(count($rsAd625) > 0){
$html.= '<a href="'.$rsAd625[$id]['AdURL'].'" target="_blank">
<img class="img-responsive box pad" src="'.AD_FILE_PATH.$rsAd625[$id]['AdImage'].'" alt="Photo">
</a>';
$Result = 'Y';
}else{
$Result = 'N';
}
$ReturnArr[3][0] = $Result;
$ReturnArr[3][1] = $html;
// End Code for 625x250 Image Slider
$objDB->objDB = $objDB->ConnectNewDatabase(DB_USERNAME,DB_PASS,DB_SERVER,DB_DATABASE);
echo json_encode($ReturnArr);
}else if($acn == "FetchRunningHoldProject"){
$SQL = "SELECT ProjectID FROM project_master WHERE ClientID = '".$objDB->ClientID."' AND ProjStatus NOT IN('close')";
$SQL_hold= " AND IsHold = 'N'";
$SQL_runing= " AND IsHold = 'Y'";
$rsHold = $objDB->sql_query($SQL.$SQL_hold);
$rsRuning = $objDB->sql_query($SQL.$SQL_runing);
if(count($rsHold) > 0 || count($rsHold) > 0){
$ReturnArr[0] = count($rsHold);
$ReturnArr[1] = count($rsRuning);
}else{
$ReturnArr[0] = "N";
$ReturnArr[1] = "No any project found..";
}
echo json_encode($ReturnArr);
}else if($acn == "Addholiday"){
if($HName == "" || $HDate == ""){
$ResultArr[0] = 'N';
}else{
$SQL = "INSERT INTO holiday SET
HName = '".AddFieldAddslashes($HName)."',
HMonth = '".date('m',strtotime($HDate))."',
HYear = '".date('Y',strtotime($HDate))."',
HDate = '".date('Y-m-d',strtotime($HDate))."',
AddedDate = '".date('Y-m-d H:s:i')."',
AddedByID = '".$_SESSION['UserInfo']['UserID']."',
AddedBy = '".$_SESSION['UserInfo']['UType']."'";
$rsInsert = $objDB->sql_query($SQL);
$ResultArr[0] = 'Y';
$ResultArr[1] = date('Y',strtotime($HDate));
}
echo json_encode($ResultArr);
exit;
}else if($acn == 'Fetchholiday'){
$FetchTabbing = FetchUserTabbing();
$AdminTabbingArr = explode(',',$FetchTabbing[0]['AdminAssignWork']);
if($HYear == ""){
$HYear = date('Y');
}
$SQL_ = "SELECT * FROM holiday WHERE HYear = '".$HYear."' ORDER BY HDate ASC";
$rsholiday = $objDB->sql_query($SQL_);
$html = '';
if(count($rsholiday) > 0){
for($i=0;$i<count($rsholiday);$i++){
$$IsActive = "";
if($rsholiday[$i]['IsActive'] == 'Y'){
$IsActive = '<a style="cursor:pointer;" onclick="javascript: ChangeHolidayStatus(\''.$i.'\',\'N\'); "><i class="fa fa-check text-primary fa-2x"></i></a>';
}else{
$IsActive = '<a style="cursor:pointer;" onclick="javascript: ChangeHolidayStatus(\''.$i.'\',\'Y\'); "><i class="fa fa-times text-red fa-2x"></i></a>';
}
$html.='<tr id="tr_'.$i.'">
<td width="10" class="text-center">'.($i+1).'</td>
<td width="250" class="text-bold"><label id="HNameText_'.$i.'">'.$rsholiday[$i]['HName'].'</label><input type="text" class="form-control col-md-6" value="'.$rsholiday[$i]['HName'].'" style="display:none;" name="HName" id="HName_'.$i.'" /></td>
<td width="150" class="text-center "><label id="HDateText_'.$i.'">'.date('d-m-Y',strtotime($rsholiday[$i]['HDate'])).'<br />'.date('l',strtotime($rsholiday[$i]['HDate'])).'</label><input type="text" class="form-control HDateAll col-md-6" style="display:none;" value="'.date('d-m-Y',strtotime($rsholiday[$i]['HDate'])).'" name="HDate" id="HDate_'.$i.'" /></td>';
if($_SESSION['UserInfo']['UType'] == "MasterAdmin" || in_array('holiday',$AdminTabbingArr)){
$html.='
<td class="text-center"><input type="hidden" style="display:none;" value="'.$rsholiday[$i]['holidayID'].'" name="HID" id="HID_'.$i.'" />'.FetchUserDetails($rsholiday[$i]['AddedByID'],$_SESSION['UserInfo']['UType']).'<br> <b><i>(# '.FetchUserUniqueID($rsholiday[$i]['AddedByID'],$_SESSION['UserInfo']['UType']).')</td>
<td class="text-center">'.$IsActive.'</td>
<td class="text-center">
<a id="editbtn_'.$i.'" style="cursor:pointer;" onclick="javascript: Editholiday('.$i.'); "><i class="fa fa-edit text-primary fa-2x"></i></a>
<a id="savebtn_'.$i.'" style="cursor:pointer; display:none;" onclick="javascript: Saveholiday('.$i.'); "><i class="fa fa-save text-green fa-2x"></i></a>
<a id="cancelbtn_'.$i.'" style="cursor:pointer; display:none;" onclick="javascript: CancelEditholiday('.$i.'); "><i class="fa fa-times text-red fa-2x"></i></a>
</td>
<td class="text-center"><a style="cursor:pointer;" id="deletebtn_'.$i.'" onclick="javascript: DeleteHoliday(\''.$i.'\',\''.$rsholiday[$i]['holidayID'].'\'); "><i class="fa fa-trash text-red fa-2x"></i></a></td>';
}
$html.='</tr>';
}
}else{
if($_SESSION['UserInfo']['UType'] == "MasterAdmin" || in_array('holiday',$AdminTabbingArr)){
$copyDiv = '<div class="col-md-12 text-center" >
<input type="button" onclick="javascript: return Copyholidays(\''.($HYear).'\');" name="Copyholidays" id="Copyholidays" class="btn btn-warning" value="Copy holiday as previous year"/>
</div>';
}
$html.='<tr><td colspan="7"></td></tr>
<tr class="text-center"><td colspan="7">No any holiday found..</td></tr>
<tr><td colspan="7"></td></tr>
<tr><td colspan="7">'.$copyDiv.'</td></tr>
';
}
$html.= '<script>$(".HDateAll").datepicker({format:"dd-mm-yyyy"});</script>';
$ResultArr[0] = 'Y';
$ResultArr[1] = $html;
echo json_encode($ResultArr);
exit;
}else if($acn == 'Editholiday'){
if($HName == "" || $HDate == "" || $HID == ""){
$ResultArr[0] = 'N';
}else{
$SQL = "UPDATE holiday SET
HName = '".AddFieldAddslashes($HName)."',
HMonth = '".date('m',strtotime($HDate))."',
HYear = '".date('Y',strtotime($HDate))."',
HDate = '".date('Y-m-d',strtotime($HDate))."' WHERE holidayID = '".$HID."' ";
$rsUpdate = $objDB->sql_query($SQL);
$ResultArr[0] = 'Y';
}
echo json_encode($ResultArr);
exit;
}else if($acn == 'ChangeholidayStatus'){
if($HID == "" || $IsActive == ""){
$ResultArr[0] = 'N';
}else{
$SQL = "UPDATE holiday SET IsActive = '".strtoupper($IsActive)."' WHERE holidayID = '".$HID."' ";
$rsUpdate = $objDB->sql_query($SQL);
$ResultArr[0] = 'Y';
}
echo json_encode($ResultArr);
exit;
}else if($acn == 'CopyHolidayDays'){
$HYear = $HYear-1;
if($HYear != ""){
$SQL_ = "SELECT * FROM holiday WHERE HYear = '".$HYear."' ORDER BY HDate ASC";
$rsHData = $objDB->sql_query($SQL_);
if(count($rsHData) > 0){
$HYear = $HYear+1;
for($i=0;$i<count($rsHData);$i++){
$HDate = date('d-m',strtotime($rsHData[$i]['HDate']));
$HDate = $HDate."-".$HYear;
$SQL = "";
$SQL = "INSERT INTO holiday SET
HName = '".AddFieldAddslashes($rsHData[$i]['HName'])."',
HMonth = '".date('m',strtotime($HDate))."',
HYear = '".date('Y',strtotime($HDate))."',
HDate = '".date('Y-m-d',strtotime($HDate))."',
AddedDate = '".date('Y-m-d H:s:i')."',
AddedByID = '".$_SESSION['UserInfo']['UserID']."',
AddedBy = '".$_SESSION['UserInfo']['UType']."'";
$rsholiday = $objDB->sql_query($SQL);
}
$ResultArr[0] = 'Y';
$ResultArr[1] = 'Holiday record copy successfully..';
}else{
$rsUpdate = $objDB->sql_query($SQL);
$ResultArr[0] = 'N';
$ResultArr[1] = 'no any record found in year '.$HYear.'..';
}
}else{
$ResultArr[0] = 'N';
$ResultArr[1] = 'Opsss! There is somthing wrong to copy holidays..';
}
echo json_encode($ResultArr);
exit;
}else if($acn == 'DeleteHoliday'){
if($HID != ""){
$SQL = "DELETE FROM `holiday` WHERE holidayID = '".$HID."'";
$rsDelete = $objDB->sql_query($SQL);
}
if($rsDelete){
$ResultArr[0] = 'Y';
$ResultArr[1] = 'Holiday deleted successfully..';
}else{
$ResultArr[0] = 'N';
$ResultArr[1] = 'Opsss! There is somthing wrong to delete holidays..';
}
echo json_encode($ResultArr);
exit;
}else if($acn == 'SETEmployeeTicketRating'){
if($TicketID != "" && $EmpID != "" && $RatingStar != ""){
$SQL = "INSERT INTO ticket_rating SET TicketID = '".$TicketID."', EmployeeID = '".$EmpID."', Rating = '".$RatingStar."',
AddedByID = '".$_SESSION['UserInfo']['UserID']."', AddedByType = '".$_SESSION['UserInfo']['UType']."', AddedDate = '".date('Y-m-d H:i:s')."'";
$rsRating = $objDB->sql_query($SQL);
$IsRun = 'Y';
}
if($rsRating && $IsRun == 'Y'){
$ResultArr[0] = 'Y';
$ResultArr[1] = 'Rating Submited Successfully..';
}else{
$ResultArr[0] = 'N';
$ResultArr[1] = 'There is somthing wrong to submit rating..';
//$ResultArr[1] = $SQL;
}
echo json_encode($ResultArr);
exit;
}else if($acn == 'ChangeDesignationMapping'){
$MappingData = json_decode($val1);
GetMappingData($MappingData,$Parent=0);
// echo "<pre>";
// print_r($MappingData);
//
// foreach($MappingData as $key=>$value){
//
// foreach($value as $key2=>$value2){
//
// echo "<br>Value>>>>>>>".$value2;
//
// echo "<br>>>key>>".$key2."";
// }
// }
//
}
}
?>