'Ahmedabad', 'Ahmedabad_AHM_102(2)'=>'Ahmedabad', 'Ahmedabad_AHM_103(1)'=>'Ahmedabad', 'Ahmedabad_AHM_104(1)'=>'Ahmedabad', 'Amazon_Facility_CRNO1'=>'Amazon', 'Amazon_Facility_CRNO2'=>'Amazon', 'Amazon_Facility_CRNO3'=>'Amazon', 'Ballabhgarh_BLB_101'=>'Ballabhgarh', 'Ballabhgarh_BLB_102'=>'Ballabhgarh', 'Ballabhgarh_BLB_103'=>'Ballabhgarh', 'Ballabhgarh_BLB_104'=>'Ballabhgarh', 'Ballabhgarh_BLB_ChillRoom'=>'Ballabhgarh', 'Ballabhgarh_BLG_201'=>'Ballabhgarh', 'Ballabhgarh_BLG_202'=>'Ballabhgarh', 'Ballabhgarh_BLG_203'=>'Ballabhgarh', 'Ballabhgarh_BLG_204_cold'=>'Ballabhgarh', 'Ballabhgarh_BLG_204_Hot'=>'Ballabhgarh', 'Ballabhgarh_BLG_205'=>'Ballabhgarh', 'Ballabhgarh_BLG_206'=>'Ballabhgarh', 'Ballabhgarh_BLG_207'=>'Ballabhgarh', 'Ballabhgarh_BLG_208'=>'Ballabhgarh', 'Ballabhgarh_Testing(1)'=>'Ballabhgarh', 'Bangalore_VGN_201(1)'=>'Bangalore', 'Bangalore_VGN_202(1)'=>'Bangalore', 'Bangalore_VGN_203(1)'=>'Bangalore', 'Bangalore_VGN_204(1)'=>'Bangalore', 'Bangalore_VGN_205L'=>'Bangalore', 'Bangalore_VGN_206(2)'=>'Bangalore', 'Bangalore_VIR_101(2)'=>'Bangalore', 'Bangalore_VIR_102(1)'=>'Bangalore', 'Bangalore_VIR_103(1)'=>'Bangalore', 'Bangalore_VIR_104(2)'=>'Bangalore', 'Bangalore_VIR_105(2)'=>'Bangalore', 'Bangalore_VIR_106(2)'=>'Bangalore', 'Bangalore_VIR_107(2)'=>'Bangalore', 'Bangalore_VIR_108(2)'=>'Bangalore', 'Bangalore_VRN_301(1)'=>'Bangalore', 'Bangalore_VRN_302(1)'=>'Bangalore', 'Bangalore_VRN_303(1)-Coldspot'=>'Bangalore', 'Bangalore_VRN_303(1)_hot'=>'Bangalore', 'Bangalore_VRN_304(1)'=>'Bangalore', 'Bangalore_VRN_305(1)'=>'Bangalore', 'Bangalore_VRN_306(1)'=>'Bangalore', 'Bangalore_VRN_307(1)'=>'Bangalore', 'Bangalore_VRN_308(1)'=>'Bangalore', 'Bangalore_VRN_309(1)'=>'Bangalore', 'Bangalore_VRN_310(1)'=>'Bangalore', 'Bangalore_VRN_311(1)'=>'Bangalore', 'Bangalore_VRN_PackingRoom(1)'=>'Bangalore', 'Bhubaneshwar_BHU_101(1)'=>'Bhubaneshwar', 'Bhubaneshwar_BHU_102(1)'=>'Bhubaneshwar', 'Bhubaneshwar_BHU_103(1)'=>'Bhubaneshwar', 'Bhubaneshwar_BHU_104(1)'=>'Bhubaneshwar', 'Bhubaneshwar_BHU_105(1)'=>'Bhubaneshwar', 'Bhubaneshwar_BHU_106(1)'=>'Bhubaneshwar', 'Bhubaneshwar_BHU_107(1)'=>'Bhubaneshwar', 'Bhubaneshwar_BHU_108(1)'=>'Bhubaneshwar', 'Chennai_CHN_101(2)'=>'Chennai', 'Chennai_CHN_102(2)'=>'Chennai', 'Chennai_CHN_103(2)'=>'Chennai', 'Chennai_CHN_104(2)'=>'Chennai', 'Chennai_CHN_201(2)'=>'Chennai', 'Chennai_CHN_202(1)'=>'Chennai', 'Chennai_CHN_203(2)'=>'Chennai', 'Chennai_CHN_204(1)'=>'Chennai', 'Chennai_CHN_205(1)'=>'Chennai', 'Chennai_CHN_206(2)'=>'Chennai', 'Chennai_CHN_207'=>'Chennai', 'Chennai_CHN_301(1)'=>'Chennai', 'Chennai_CHN_302(1)'=>'Chennai', 'Chennai_CHN_303(1)'=>'Chennai', 'Chennai_CHN_304(1)'=>'Chennai', 'Chennai_CHN_502(1)_cold'=>'Chennai', 'Chennai_CHN_ChillRoomA(1)'=>'Chennai', 'Chennai_CHN_ChillRoomB(1)'=>'Chennai', 'Chennai_CHN_ChillRoomC(1)'=>'Chennai', 'Chennai_CHN_ChillRoomD(1)'=>'Chennai', 'Chennai_CHN_ChillRoomE(1)'=>'Chennai', 'Chennai_CNE_501(2)'=>'Chennai', 'Chennai_CNE_502(HOT)'=>'Chennai', 'Chennai_CNE_503(1)'=>'Chennai', 'Chennai_CNE_504(1)'=>'Chennai', 'Chennai_CNE_505(1)'=>'Chennai', 'Chennai_CNE_506(2)'=>'Chennai', 'Chennai_CNE_507(2)'=>'Chennai', 'Chennai_CNE_508(1)'=>'Chennai', 'Chennai_CNE_509(1)'=>'Chennai', 'Chennai_CNE_510(1)'=>'Chennai', 'Chennai_CNE_511(1)'=>'Chennai', 'Chennai_CNE_512(1)'=>'Chennai', 'Chennai_CNE_513(1)'=>'Chennai', 'Chennai_CNN_401(1)'=>'Chennai', 'Chennai_CNN_402(1)'=>'Chennai', 'Chennai_CNN_403(1)'=>'Chennai', 'Chennai_CNN_404(1)'=>'Chennai', 'Cochin_CON_ChillRoom(1)'=>'Cochin', 'Cochin_CON_201(1)'=>'Cochin', 'Cochin_CON_202(1)'=>'Cochin', 'Cochin_CON_203(1)'=>'Cochin', 'Cochin_CON_204(1)'=>'Cochin', 'Cochin_CON_205(1)'=>'Cochin', 'Cochin_CON_206(1)'=>'Cochin', 'Cochin_CON_207(1)'=>'Cochin', 'Cochin_CON_208(1)'=>'Cochin', 'Cochin_CON_209(1)'=>'Cochin', 'Cochin_CON_210(1)'=>'Cochin', 'Derabassi_PUJ_101(1)'=>'Derabassi', 'Derabassi_PUJ_102(1)'=>'Derabassi', 'Derabassi_PUJ_103(2)'=>'Derabassi', 'Derabassi_PUJ_104L'=>'Derabassi', 'Derabassi_PUJ_105(1)'=>'Derabassi', 'Derabassi_PUJ_106(1)'=>'Derabassi', 'Derabassi_PUJ_107(1)'=>'Derabassi', 'Derabassi_PUJ_108(2)'=>'Derabassi', 'Derabassi_PUJ_109(2)'=>'Derabassi', 'Derabassi_PUJ_110R'=>'Derabassi', 'Hyderabad_HYD_101(1)'=>'Hyderabad', 'Hyderabad_HYD_102'=>'Hyderabad', 'Hyderabad_HYD_102A'=>'Hyderabad', 'Hyderabad_HYD_103'=>'Hyderabad', 'Hyderabad_HYD_104'=>'Hyderabad', 'Hyderabad_HYD_105'=>'Hyderabad', 'Hyderabad_HYD_106'=>'Hyderabad', 'Jaipur_JPU_101(1)'=>'Jaipur', 'Jaipur_JPU_102(1)'=>'Jaipur', 'Jaipur_JPU_103(1)'=>'Jaipur', 'Jaipur_JPU_104(1)'=>'Jaipur', 'Jaipur_JPU_105'=>'Jaipur', 'Jaipur_JPU_106(1)'=>'Jaipur', 'Jaipur_JPU_107(1)'=>'Jaipur', 'Jaipur_JPU_108(1)'=>'Jaipur', 'Jaipur_JPU_109'=>'Jaipur', 'Jaipurchamber10(1)'=>'Jaipurchamber', 'Kolkata_KKT_101(1)'=>'Kolkata', 'Kolkata_KKT_102(1)_Hot'=>'Kolkata', 'Kolkata_KKT_102_Cold '=>'Kolkata', 'Kolkata_KKT_103(2)'=>'Kolkata', 'Kolkata_KKT_104(2)'=>'Kolkata', 'Kolkata_KKT_105(2)'=>'Kolkata', 'Kolkata_KKT_106(1)'=>'Kolkata', 'Kolkata_KKT_107(1)'=>'Kolkata', 'Kolkata_KKT_108(2)'=>'Kolkata', 'Kolkata_KKT_109(2)'=>'Kolkata', 'Kolkata_KKT_110(2)'=>'Kolkata', 'Kolkata_KKT_201(1)'=>'Kolkata', 'Kolkata_KKT_202(1)'=>'Kolkata', 'Kolkata_KOL_101(2)'=>'Kolkata', 'Kolkata_KOL_102(2)'=>'Kolkata', 'Kolkata_KOL_103(2)'=>'Kolkata', 'Kolkata_KOL_104(2)'=>'Kolkata', 'Krishnapatnam_KPM_101(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_102(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_103(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_104(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_105(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_106(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_107(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_108(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_109(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_110(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_111(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_112(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_113(1)'=>'Krishnapatnam', 'Krishnapatnam_KPM_Packing Room'=>'Krishnapatnam', 'Mumbai_M55_101'=>'Mumbai', 'Mumbai_M55_103'=>'Mumbai', 'Mumbai_M55_104'=>'Mumbai', 'MumbaiK12_MMA_601(1)_Cold'=>'Mumbai', 'MumbaiK12_MMA_601(1)_HOT'=>'Mumbai', 'MumbaiK12_MMA_602(1)_COLD'=>'Mumbai', 'MumbaiK12_MMA_602(1)_HOT'=>'Mumbai', 'MumbaiK12_MMA_603(1)_COLD'=>'Mumbai', 'MumbaiK12_MMA_603(1)_HOT'=>'Mumbai', 'MumbaiK12_MMA_604(1)_ COLD'=>'Mumbai', 'MumbaiK12_MMA_604(1)_ HOT'=>'Mumbai', 'MumbaiK12_MMA_605(1)_ COLD'=>'Mumbai', 'MumbaiK12_MMA_605(1)_ HOT'=>'Mumbai', 'MumbaiK12_MMA_606(1)_COLD'=>'Mumbai', 'MumbaiK12_MMA_606(1)_HOT'=>'Mumbai', 'MumbaiK12_MMA_607(1)_HOT'=>'Mumbai', 'MumbaiK12_MMA_607_COLD'=>'Mumbai', 'MumbaiK12_MMA_608(1)_COLD'=>'Mumbai', 'MumbaiK12_MMA_608(1)_HOT'=>'Mumbai', 'MumbaiK12_MMA_609(1)_Cold'=>'Mumbai', 'MumbaiK12_MMA_609(1)_HOT'=>'Mumbai', 'MumbaiK12_MMA_610(1)_COLD'=>'Mumbai', 'MumbaiK12_MMA_610(1)_HOT'=>'Mumbai', 'MumbaiM32_MBI_501(1)'=>'Mumbai', 'MumbaiM32_MBI_502(2)'=>'Mumbai', 'MumbaiM32_MBI_503(2)'=>'Mumbai', 'MumbaiM32_MBI_504(2)'=>'Mumbai', 'MumbaiM32_MBI_505'=>'Mumbai', 'MumbaiM32_MBI_506(2)'=>'Mumbai', 'MumbaiM32_MBI_507(1)'=>'Mumbai', 'MumbaiM32_MBI_508(1)'=>'Mumbai', 'MumbaiM32_MBI_509(2)'=>'Mumbai', 'MumbaiM32_MBI_510(2)'=>'Mumbai', 'MumbaiM32_MBI_511(1)'=>'Mumbai', 'MumbaiM32_MBI_512(2)'=>'Mumbai', 'MumbaiM32_MBI_513'=>'Mumbai', 'MumbaiM32_MBI_514(1)'=>'Mumbai', 'MumbaiM55102 '=>' Mumbai', 'MumbaiM8_CS1_201(1)'=>'Mumbai', 'MumbaiM8_CS1_202'=>'Mumbai', 'MumbaiM8_CS1_203(2)'=>'Mumbai', 'MumbaiM8_CS1_204'=>'Mumbai', 'MumbaiM8_CS1_205(1)'=>'Mumbai', 'MumbaiM8_CS1_206'=>'Mumbai', 'MumbaiM8_CS1_207(2)'=>'Mumbai', 'MumbaiM8_CS1_208(2)'=>'Mumbai', 'MumbaiM8_CS2_301(1)'=>'Mumbai', 'MumbaiM8_CS2_302'=>'Mumbai', 'MumbaiM8_CS2_303(2)'=>'Mumbai', 'MumbaiM8_CS2_304(2)'=>'Mumbai', 'MumbaiM8_CS2_305(2)'=>'Mumbai', 'MumbaiM8_CS2_306(1)'=>'Mumbai', 'MumbaiM8_CS2_307(2)'=>'Mumbai', 'MumbaiM8_CS2_308(2)'=>'Mumbai', 'MumbaiM8_CS2_309(2)'=>'Mumbai', 'MumbaiM8_CS2_310(2)'=>'Mumbai', 'MumbaiM8_CS3_401'=>'Mumbai', 'MumbaiM8_CS3_402'=>'Mumbai', 'MumbaiM8_CS3_403'=>'Mumbai', 'MumbaiM8_CS3_404'=>'Mumbai', 'MumbaiM8_CS3_405'=>'Mumbai', 'MumbaiM8_CS3_406'=>'Mumbai', 'MumbaiM8_CS3_407'=>'Mumbai', 'MumbaiM8_CS3_408'=>'Mumbai', 'Pune_Amazon_CHILL01'=>'Pune', 'Pune_Amazon_FROZ01'=>'Pune', 'Pune_Amazon_TROP01'=>'Pune', 'Pune_Amazon_TROP02'=>'Pune', 'Pune_PNE_201'=>'Pune', 'Pune_PNE_202'=>'Pune', 'Pune_PNE_203(2)'=>'Pune', 'Pune_PNE_204(2)'=>'Pune', 'Pune_PNN_301(2)'=>'Pune', 'Pune_PNN_302(2)'=>'Pune', 'Pune_PNN_303(1)'=>'Pune', 'Pune_PNN_304'=>'Pune', 'Pune_PNN_305(1)'=>'Pune', 'Pune_PNN_306(1)'=>'Pune', 'Pune_PNN_307'=>'Pune', 'Pune_PNN_308(2)'=>'Pune', 'Pune_PUN_101(2)'=>'Pune', 'Pune_PUN_102(2)'=>'Pune', 'Pune_PUN_103(1)'=>'Pune', 'Pune_PUN_104(1)'=>'Pune', 'siliguri_(101)'=>'siliguri', 'siliguri_(102)'=>'siliguri', 'siliguri_(103)'=>'siliguri', 'siliguri_(104)'=>'siliguri', 'siliguri_(105)'=>'siliguri', 'siliguri_(106)'=>'siliguri', 'siliguri_(107)'=>'siliguri', 'siliguri_(108)'=>'siliguri', 'siliguri_(109)'=>'siliguri', 'Surat_SUR_101(2)'=>'Surat', 'Surat_SUR_102(2)'=>'Surat', 'Surat_SUR_103(1)'=>'Surat', 'Surat_SUR_104(1)'=>'Surat', 'Surat_SUR_105(2)'=>'Surat', 'Surat_SUR_106(2)'=>'Surat', 'Surat_SUR_107(1)'=>'Surat', 'Surat_SUR_108(1)'=>'Surat', 'Surat_SUR_109(2)'=>'Surat', 'Surat_SUR_110(2)'=>'Surat', 'Vizag_VIG_301(1)'=>'Vizag', 'Vizag_VIG_302(1)'=>'Vizag', 'Vizag_VIG_303(2)'=>'Vizag', 'Vizag_VIG_304(2)'=>'Vizag', 'Vizag_VIG_305(2)'=>'Vizag', 'Vizag_VIG_306(2)'=>'Vizag', 'Vizag_VIG_307(2)'=>'Vizag', 'Vizag_VIG_308(2)'=>'Vizag', 'Vizag_VIG_309(1)'=>'Vizag', 'Vizag_VIG_310(1)'=>'Vizag', 'Vizag_VIG_PackingRoom(1)'=>'Vizag', 'Vizag_VIZ_101(2)'=>'Vizag', 'Vizag_VIZ_102(2)'=>'Vizag', 'Vizag_VIZ_104(1)'=>'Vizag', 'Vizag_VIZ_201(1)'=>'Vizag', 'Vizag_VIZ_202(1)'=>'Vizag', 'Vizag_VIZ_203(1)'=>'Vizag', 'Vizag_VIZ_204(1)'=>'Vizag', 'Vizag_VIZ_205(1)'=>'Vizag', 'Vizag_VIZ_206(1)'=>'Vizag', 'Vizag_VIZ_207(1)'=>'Vizag', 'Vizag_VIZ_208(1)'=>'Vizag', 'Vizag_VIZ_209(1)'=>'Vizag', 'Vizag_VIZ_PackingRoom(1)'=>' Vizag', 'Coimbatore_107'=>'Coimbatore', 'Coimbatore_108'=>'Coimbatore' ); $SelectCitydata = array( 'Ahmedabad_AHM_101(2)'=>'Ahmedabad', 'Amazon_Facility_CRNO1'=>'Amazon', 'Ballabhgarh_BLB_101'=>'Ballabhgarh', 'Bangalore_VGN_201(1)'=>'Bangalore', 'Bhubaneshwar_BHU_108(1)'=>'Bhubaneshwar', 'Chennai_CHN_101(2)'=>'Chennai', 'Chennai_CNN_404(1)'=>'Chennai', 'Cochin_CON_ChillRoom(1)'=>'Cochin', 'Derabassi_PUJ_101(1)'=>'Derabassi', 'Hyderabad_HYD_101(1)'=>'Hyderabad', 'Jaipur_JPU_101(1)'=>'Jaipur', 'Jaipurchamber10(1)'=>'Jaipurchamber', 'Kolkata_KKT_101(1)'=>'Kolkata', 'Krishnapatnam_KPM_101(1)'=>'Krishnapatnam', 'MumbaiM8_CS3_408'=>'Mumbai', 'Pune_Amazon_CHILL01'=>'Pune', 'siliguri_(101)'=>'siliguri', 'Surat_SUR_110(2)'=>'Surat', 'Vizag_VIG_301(1)'=>'Vizag', ); $AllcityName = array('Delhi', 'Mumbai', 'Jaipur', 'Ahmedabad', 'Kolkata', 'Ballabhgarh', 'Bangalore', 'Bhubaneshwar', 'Chennai','Cochin','Derabassi','Hyderabad','Krishnapatnam','Pune','siliguri','Surat','Vizag'); // echo "
"; 
// echo json_encode($AllcityName);
// //print_r($AllcityName);
// echo "
"; $masterObj = new master(); $previousdate = date("Y-m-d 00:00:59"); $lastsixMonth = date("Y-m-d 00:00:59", strtotime("-6 months")); $lastOneMonth = date("Y-m-d 00:00:59", strtotime("-1 months")); $lastweek = date("Y-m-d 00:00:59", strtotime("-7 days")); $yesterday = date("Y-m-d 00:00:59", strtotime("-1 days")); $last24Hours = date("Y-m-d H:i:s", strtotime("-24 hours")); $curruntDate = date("Y-m-d H:i:s"); // ************************** $date = date('Y-m-d', strtotime('-1 day', strtotime(date('Y-m-d')))); $UserId = $_SESSION['UserId']; $AllvehicleDetails = $masterObj->getAllVechiles($_SESSION['vehId'],$date); // ************************** $cityData = $masterObj->getCity_data(); $raisedTicket = $masterObj->getdebug_data(false,'1,2,3,4,5,6,11'); $wokingNotworkingChambers = $masterObj->working_notworking_Chamber($_SESSION['vehId']); $notworking = $masterObj->notworking_vehicle_Chamber(); $alldata = $masterObj->getAllStatus_data($previousdate,false,false,false); $tempreturIssue1 = $masterObj->tempretur_Issue($previousdate); $workingVehicleDelhi1 = $masterObj->getAllStatus_data($lastsixMonth,false,$last24Hours,$curruntDate); $NotworkingVehicleDelhi1 = $masterObj->getAllStatus_data($lastsixMonth,false, $lastsixMonth,$last24Hours); $tempreturIssue = []; $gpsIssue = []; $doorIssue = []; $Serviceissue = []; $AssignedTicket = []; $onHoldTicket = []; $runningTicket = []; $ClosedTicket = []; $cityids = array(); $cityvalues = array(); // not working vehicle $notworkingdelhi = array(); $notworkingMumbai = array(); $notworkingJaipur = array(); $notworkingAhmedabad = array(); $notworkingKolkata = array(); $notworkingBallabhgarh = array(); $notworkingBangalore = array(); $notworkingBhubaneshwar = array(); $notworkingChennai = array(); $notworkingCochin = array(); $notworkingDerabassi = array(); $notworkingHyderabad = array(); $notworkingKrishnapatnam = array(); $notworkingPune = array(); $notworkingsiliguri = array(); $notworkingSurat = array(); $notworkingVizag = array(); $notworkingAmazon = array(); // working vehicle $workingdelhi = array(); $workingMumbai = array(); $workingJaipur = array(); $workingAhmedabad = array(); $workingKolkata = array(); $workingBallabhgarh = array(); $workingBangalore = array(); $workingBhubaneshwar = array(); $workingChennai = array(); $workingCochin = array(); $workingDerabassi = array(); $workingHyderabad = array(); $workingKrishnapatnam = array(); $workingPune = array(); $workingsiliguri = array(); $workingSurat = array(); $workingVizag = array(); $workingAmazon = array(); // tempreture issue not woking $tempNotworkingdelhi = array(); $tempNotworkingMumbai = array(); $tempNotworkingJaipur = array(); $tempNotworkingAhmedabad = array(); $tempNotworkingKolkata = array(); $tempNotworkingBallabhgarh = array(); $tempNotworkingBangalore = array(); $tempNotworkingBhubaneshwar = array(); $tempNotworkingChennai = array(); $tempNotworkingCochin = array(); $tempNotworkingDerabassi = array(); $tempNotworkingHyderabad = array(); $tempNotworkingKrishnapatnam = array(); $tempNotworkingPune = array(); $tempNotworkingsiliguri = array(); $tempNotworkingSurat = array(); $tempNotworkingVizag = array(); $tempNotworkingAmazon = array(); // tempreture issue woking $tempWorkingdelhi = array(); $tempWorkingMumbai = array(); $tempWorkingJaipur = array(); $tempWorkingAhmedabad = array(); $tempWorkingKolkata = array(); $tempWorkingBallabhgarh = array(); $tempWorkingBangalore = array(); $tempWorkingBhubaneshwar = array(); $tempWorkingChennai = array(); $tempWorkingCochin = array(); $tempWorkingDerabassi = array(); $tempWorkingHyderabad = array(); $tempWorkingKrishnapatnam = array(); $tempWorkingPune = array(); $tempWorkingsiliguri = array(); $tempWorkingSurat = array(); $tempWorkingVizag = array(); $tempWorkingAmazon = array(); // GPS issue Not working $gpsNotworkingdelhi = array(); $gpsNotworkingMumbai = array(); $gpsNotworkingJaipur = array(); $gpsNotworkingAhmedabad = array(); $gpsNotworkingKolkata = array(); $gpsNotworkingBallabhgarh = array(); $gpsNotworkingBangalore = array(); $gpsNotworkingBhubaneshwar = array(); $gpsNotworkingChennai = array(); $gpsNotworkingCochin = array(); $gpsNotworkingDerabassi = array(); $gpsNotworkingHyderabad = array(); $gpsNotworkingKrishnapatnam = array(); $gpsNotworkingPune = array(); $gpsNotworkingsiliguri = array(); $gpsNotworkingSurat = array(); $gpsNotworkingVizag = array(); $gpsNotworkingAmazon = array(); // GPS issue woking $gpsWorkingdelhi = array(); $gpsWorkingMumbai = array(); $gpsWorkingJaipur = array(); $gpsWorkingAhmedabad = array(); $gpsWorkingKolkata = array(); $gpsWorkingBallabhgarh = array(); $gpsWorkingBangalore = array(); $gpsWorkingBhubaneshwar = array(); $gpsWorkingChennai = array(); $gpsWorkingCochin = array(); $gpsWorkingDerabassi = array(); $gpsWorkingHyderabad = array(); $gpsWorkingKrishnapatnam = array(); $gpsWorkingPune = array(); $gpsWorkingsiliguri = array(); $gpsWorkingSurat = array(); $gpsWorkingVizag = array(); $gpsWorkingAmazon = array(); // DOOR issue Not working $doorNotworkingdelhi = array(); $doorNotworkingMumbai = array(); $doorNotworkingJaipur = array(); $doorNotworkingAhmedabad = array(); $doorNotworkingKolkata = array(); $doorNotworkingBallabhgarh = array(); $doorNotworkingBangalore = array(); $doorNotworkingBhubaneshwar = array(); $doorNotworkingChennai = array(); $doorNotworkingCochin = array(); $doorNotworkingDerabassi = array(); $doorNotworkingHyderabad = array(); $doorNotworkingKrishnapatnam = array(); $doorNotworkingPune = array(); $doorNotworkingsiliguri = array(); $doorNotworkingSurat = array(); $doorNotworkingVizag = array(); $doorNotworkingAmazon = array(); // DOOR issue woking $doorWorkingdelhi = array(); $doorWorkingMumbai = array(); $doorWorkingJaipur = array(); $doorWorkingAhmedabad = array(); $doorWorkingKolkata = array(); $doorWorkingBallabhgarh = array(); $doorWorkingBangalore = array(); $doorWorkingBhubaneshwar = array(); $doorWorkingChennai = array(); $doorWorkingCochin = array(); $doorWorkingDerabassi = array(); $doorWorkingHyderabad = array(); $doorWorkingKrishnapatnam = array(); $doorWorkingPune = array(); $doorWorkingsiliguri = array(); $doorWorkingSurat = array(); $doorWorkingVizag = array(); $doorWorkingAmazon = array(); // Service issue Not working $ServiceNotworkingdelhi = array(); $ServiceNotworkingMumbai = array(); $ServiceNotworkingJaipur = array(); $ServiceNotworkingAhmedabad = array(); $ServiceNotworkingKolkata = array(); $ServiceNotworkingBallabhgarh = array(); $ServiceNotworkingBangalore = array(); $ServiceNotworkingBhubaneshwar = array(); $ServiceNotworkingChennai = array(); $ServiceNotworkingCochin = array(); $ServiceNotworkingDerabassi = array(); $ServiceNotworkingHyderabad = array(); $ServiceNotworkingKrishnapatnam = array(); $ServiceNotworkingPune = array(); $ServiceNotworkingsiliguri = array(); $ServiceNotworkingSurat = array(); $ServiceNotworkingVizag = array(); $ServiceNotworkingAmazon = array(); //Service issue woking $ServiceWorkingdelhi = array(); $ServiceWorkingMumbai = array(); $ServiceWorkingJaipur = array(); $ServiceWorkingAhmedabad = array(); $ServiceWorkingKolkata = array(); $ServiceWorkingBallabhgarh = array(); $ServiceWorkingBangalore = array(); $ServiceWorkingBhubaneshwar = array(); $ServiceWorkingChennai = array(); $ServiceWorkingCochin = array(); $ServiceWorkingDerabassi = array(); $ServiceWorkingHyderabad = array(); $ServiceWorkingKrishnapatnam = array(); $ServiceWorkingPune = array(); $ServiceWorkingsiliguri = array(); $ServiceWorkingSurat = array(); $ServiceWorkingVizag = array(); $ServiceWorkingAmazon = array(); $alltempWorking = array(); $alldoorWorking = array(); $allNottempWorking = array(); //$allNotdoorWorking = array(); // echo '
';
          //  print_r($_SESSION); 
          //  echo '
'; // die; //print_r($_SESSION); // echo $_SESSION['UserId'].'<====>'.$_SESSION['sys_group_id']; foreach ($wokingNotworkingChambers as $key => $value) { if (array_key_exists($value['veh_reg'],$Allcitydata)) { $cityname = ''; foreach ($Allcitydata as $k => $val) { if ($value['veh_reg'] == $k) { if ($val =='Pune') { if ($value['HourDiff'] > 24) { array_push($notworkingPune,$val); }else{ array_push($workingPune,$val); } }if ($val =='Chennai') { if ($value['HourDiff'] > 24) { array_push($notworkingChennai,$val); }else{ array_push($workingChennai,$val); } }if ($val =='Mumbai') { if ($value['HourDiff'] > 24) { array_push($notworkingMumbai,$val); }else{ array_push($workingMumbai,$val); } }if ($val =='Krishnapatnam') { if ($value['HourDiff'] > 24) { array_push($notworkingKrishnapatnam,$val); }else{ array_push($workingKrishnapatnam,$val); } }if ($val =='Kolkata') { if ($value['HourDiff'] > 24) { array_push($notworkingKolkata,$val); }else{ array_push($workingKolkata,$val); } }if ($val =='Hyderabad') { if ($value['HourDiff'] > 24) { array_push($notworkingHyderabad,$val); }else{ array_push($workingHyderabad,$val); } }if ($val =='Surat') { if ($value['HourDiff'] > 24) { array_push($notworkingSurat,$val); }else{ array_push($workingSurat,$val); } }if ($val =='Ballabhgarh') { if ($value['HourDiff'] > 24) { array_push($notworkingBallabhgarh,$val); }else{ array_push($workingBallabhgarh,$val); } }if ($val =='Bangalore') { if ($value['HourDiff'] > 24) { array_push($notworkingBangalore,$val); }else{ array_push($workingBangalore,$val); } }if ($val =='Derabassi') { if ($value['HourDiff'] > 24) { array_push($notworkingDerabassi,$val); }else{ array_push($workingDerabassi,$val); } }if ($val =='Bhubaneshwar') { if ($value['HourDiff'] > 24) { array_push($notworkingBhubaneshwar,$val); }else{ array_push($workingBhubaneshwar,$val); } }if ($val =='Vizag') { if ($value['HourDiff'] > 24) { array_push($notworkingVizag,$val); }else{ array_push($workingVizag,$val); } }if ($val =='Cochin') { if ($value['HourDiff'] > 24) { array_push($notworkingCochin,$val); }else{ array_push($workingCochin,$val); } }if ($val =='Amazon') { if ($value['HourDiff'] > 24) { array_push($notworkingAmazon,$val); }else{ array_push($workingAmazon,$val); } }if ($val =='delhi') { if ($value['HourDiff'] > 24) { array_push($notworkingdelhi,$val); }else{ array_push($workingdelhi,$val); } }if ($val =='Jaipur') { if ($value['HourDiff'] > 24) { array_push($notworkingJaipur,$val); }else{ array_push($workingJaipur,$val); } }if ($val =='siliguri') { if ($value['HourDiff'] > 24) { array_push($notworkingsiliguri,$val); }else{ array_push($workingsiliguri,$val); } }if ($val =='Ahmedabad') { if ($value['HourDiff'] > 24) { array_push($notworkingAhmedabad,$val); }else{ array_push($workingAhmedabad,$val); } } } } } } foreach ($workingVehicleDelhi1 as $key => $value) { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($alltempWorking , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($alldoorWorking , 1); } if (array_key_exists($value['veh_reg'],$Allcitydata)) { $cityname = ''; foreach ($Allcitydata as $k => $val) { if ($value['veh_reg'] == $k) { if ($val =='Pune') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingPune , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingPune , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingPune , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingPune , 1); } //array_push($workingPune,$val); }if ($val =='Chennai') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingChennai , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingChennai , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingChennai , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingChennai , 1); } //array_push($workingChennai,$val); }if ($val =='Mumbai') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingMumbai , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingMumbai , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingMumbai , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingMumbai , 1); } //array_push($workingMumbai,$val); }if ($val =='Krishnapatnam') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingKrishnapatnam , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingKrishnapatnam , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingKrishnapatnam , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingKrishnapatnam , 1); } //array_push($workingKrishnapatnam,$val); }if ($val =='Kolkata') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingKolkata , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingKolkata , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingKolkata , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingKolkata , 1); } //array_push($workingKolkata,$val); }if ($val =='Hyderabad') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingHyderabad , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingHyderabad , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingHyderabad , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingHyderabad , 1); } //array_push($workingHyderabad,$val); }if ($val =='Surat') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingSurat , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingSurat , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingSurat , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingSurat , 1); } //array_push($workingSurat,$val); }if ($val =='Ballabhgarh') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingBallabhgarh , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingBallabhgarh , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingBallabhgarh , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingBallabhgarh , 1); } //array_push($workingBallabhgarh,$val); }if ($val =='Bangalore') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingBangalore , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingBangalore , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingBangalore , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingBangalore , 1); } //array_push($workingBangalore,$val); }if ($val =='Derabassi') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingDerabassi , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingDerabassi , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingDerabassi , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingDerabassi , 1); } //array_push($workingDerabassi,$val); }if ($val =='Bhubaneshwar') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingBhubaneshwar , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingBhubaneshwar , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingBhubaneshwar , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingBhubaneshwar , 1); } //array_push($workingBhubaneshwar,$val); }if ($val =='Vizag') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingVizag , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingVizag , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingVizag , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingVizag , 1); } //array_push($workingVizag,$val); }if ($val =='Cochin') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingCochin , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingCochin , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingCochin , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingCochin , 1); } //array_push($workingCochin,$val); }if ($val =='Amazon') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingAmazon , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingAmazon , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingAmazon , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingAmazon , 1); } //array_push($workingAmazon,$val); }if ($val =='delhi') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingdelhi , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingdelhi , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingdelhi , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingdelhi , 1); } //array_push($workingdelhi,$val); }if ($val =='Jaipur') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingJaipur , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingJaipur , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingJaipur , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingJaipur , 1); } //array_push($workingJaipur,$val); }if ($val =='siliguri') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingsiliguri , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingsiliguri , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingsiliguri , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingsiliguri , 1); } //array_push($workingsiliguri,$val); }if ($val =='Ahmedabad') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempWorkingAhmedabad , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorWorkingAhmedabad , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsWorkingAhmedabad , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceWorkingAhmedabad , 1); } //array_push($workingAhmedabad,$val); } } } } } foreach ($NotworkingVehicleDelhi1 as $key => $value) { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($allNottempWorking , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($allNotdoorWorking , 1); } if (array_key_exists($value['veh_reg'],$Allcitydata)) { $cityname = ''; foreach ($Allcitydata as $k => $val) { if ($value['veh_reg'] == $k) { if ($val =='Pune') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingPune , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingPune , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingPune , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingPune , 1); } // array_push($notworkingPune,$val); }if ($val =='Chennai') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingChennai , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingChennai , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingChennai , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingChennai , 1); } // array_push($notworkingChennai,$val); } if ($val =='Mumbai') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingMumbai , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingMumbai , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingMumbai , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingMumbai , 1); } // array_push($notworkingMumbai,$val); }if ($val =='Krishnapatnam') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingKrishnapatnam , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingKrishnapatnam , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingKrishnapatnam , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingKrishnapatnam , 1); } // array_push($notworkingKrishnapatnam,$val); } if ($val =='Kolkata') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingKolkata , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingKolkata , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingKolkata , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingKolkata , 1); } // array_push($notworkingKolkata,$val); }if ($val =='Hyderabad') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingHyderabad , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingHyderabad , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingHyderabad , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingHyderabad , 1); } // array_push($notworkingHyderabad,$val); } if ($val =='Surat') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingSurat , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingSurat , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingSurat , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingSurat , 1); } //array_push($notworkingSurat,$val); }if ($val =='Ballabhgarh') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingBallabhgarh , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingBallabhgarh , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingBallabhgarh , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingBallabhgarh , 1); } //array_push($notworkingBallabhgarh,$val); } if ($val =='Bangalore') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingBangalore , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingBangalore , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingBangalore , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingBangalore , 1); } ///array_push($notworkingBangalore,$val); }if ($val =='Derabassi') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingDerabassi , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingDerabassi , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingDerabassi , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingDerabassi , 1); } //array_push($notworkingDerabassi,$val); } if ($val =='Bhubaneshwar') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingBhubaneshwar , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingBhubaneshwar , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingBhubaneshwar , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingBhubaneshwar , 1); } //array_push($notworkingBhubaneshwar,$val); }if ($val =='Vizag') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingVizag , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingVizag , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingVizag , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingVizag , 1); } //array_push($notworkingVizag,$val); } if ($val =='Cochin') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingCochin , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingCochin , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingCochin , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingCochin , 1); } // array_push($notworkingCochin,$val); }if ($val =='Amazon') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingAmazon , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingAmazon , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingAmazon , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingAmazon , 1); } //array_push($notworkingAmazon,$val); } if ($val =='delhi') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingdelhi , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingdelhi , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingdelhi , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingdelhi , 1); } //array_push($notworkingdelhi,$val); } if ($val =='Jaipur') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingJaipur , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingJaipur , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingJaipur , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingJaipur , 1); } //array_push($notworkingJaipur,$val); } if ($val =='siliguri') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingsiliguri , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingsiliguri , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingsiliguri , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingsiliguri , 1); } //array_push($notworkingsiliguri,$val); }if ($val =='Ahmedabad') { if(strpos($value['comment'], "temprature") !== false || strpos($value['comment'], "TEMPRATURE") !== false){ array_push($tempNotworkingAhmedabad , 1); } if(strpos($value['comment'], "door") !== false || strpos($value['comment'], "DOOR") !== false){ array_push($doorNotworkingAhmedabad , 1); } if(strpos($value['comment'], "GPS") !== false || strpos($value['comment'], "gps") !== false){ array_push($gpsNotworkingAhmedabad , 1); } if(strpos($value['comment'], "Service") !== false || strpos($value['comment'], "SERVICE") !== false){ array_push($ServiceNotworkingAhmedabad , 1); } //array_push($notworkingAhmedabad,$val); } } } } } // echo count($allNotdoorWorking).'<===>'.count($alldoorWorking).'<=====>'.count($alltempWorking).'<=====>'.count($allNottempWorking).'
'; foreach ($raisedTicket as $key => $value) { if ($value['service_status'] ==1 || $value['service_status'] ==2 || $value['service_status'] ==3 || $value['service_status'] ==4 || $value['service_status'] ==5 || $value['service_status'] ==6 || $value['service_status'] == 11) { array_push($AssignedTicket, 1); } if ($value['service_status'] ==3 || $value['service_status'] ==4) { array_push($onHoldTicket, 1); } if ($value['service_status'] ==1 || $value['service_status'] ==2 || $value['service_status'] ==11) { array_push($runningTicket, 1); } if ($value['service_status'] ==5 || $value['service_status'] ==6) { array_push($ClosedTicket, 1); } } foreach ($tempreturIssue1 as $key => $value) { if(strpos($value['comment'], "TEMPERATURE") !== false){ array_push($tempreturIssue , 1); }if(strpos($value['comment'], "GPS") !== false){ array_push($gpsIssue , 1); }if(strpos($value['comment'], "door") !== false){ array_push($doorIssue , 1); }if(strpos($value['comment'], "Service") !== false){ array_push($Serviceissue , 1); } } $raisedPrctg = count($raisedTicket)*100 /count($alldata); $runningTicketper = count($runningTicket)*100 /count($alldata); $assignPrctg = count($AssignedTicket)*100 /count($alldata); $onHoldPrctg = count($onHoldTicket)*100 /count($alldata); $closedPrctg = count($ClosedTicket)*100 /count($alldata); if (count($doorIssue) > 0 && count($raisedTicket) >0) { $doorIsue = count($doorIssue)*100 /count($raisedTicket); }else{ $doorIsue = 0; }if (count($tempreturIssue) > 0 && count($raisedTicket) >0) { $tempIsue = count($tempreturIssue)*100 /count($raisedTicket); }else{ $tempIsue = 0; }if (count($gpsIssue) > 0 && count($raisedTicket) >0) { $gpsIsue = count($gpsIssue)*100 /count($raisedTicket); }else{ $gpsIsue = 0; }if (count($Serviceissue) > 0 && count($raisedTicket) >0) { $Serviceissue = count($Serviceissue)*100 /count($raisedTicket); }else{ $Serviceissue = 0; } if($_POST['status'] || $_POST['cityId'] || $_POST['previousdays']) { $ticketRaised22 = array(); $statusType = $_POST['status']!=''? $_POST['status'] : '1,2,3,4,5,6,11'; $cityId = $_POST['cityId']!=''? $_POST['cityId'] : false; $previous = $_POST['previousdays']!='' ? $_POST['previousdays'] : false; $raisedTicket = $masterObj->getdebug_data($cityId,$statusType,$previous); foreach ($raisedTicket as $key => $value) { if (array_key_exists($value['veh_reg'],$Allcitydata)) { $cityname = ''; foreach ($Allcitydata as $k => $val) { if ($value['veh_reg'] == $k) { $cityname = $val; } } } if($value['veh_reg']){ $getLastsix = $masterObj->getAllStatus_data($previousdate,$value['veh_reg']); } $date1_ts = strtotime($value['Notwoking']); $date2_ts = strtotime(date('Y-m-d H:i:s')); $fromtime = strtotime($value['req_date']); $totime = strtotime($value['time']); if ($value['req_date'] && $value['time']) { $hourdiff1 = round((strtotime($value['time']) - strtotime($value['req_date']))/3600, 2); $hourdiff = $hourdiff1.' hour'; }else{ $hourdiff1 = round((strtotime($value['atimeto']) - strtotime($value['req_date']))/3600, 2); $hourdiff = $hourdiff1.' hour'; } $difftime = $totime - $fromtime; // echo $value['req_date'].'<====>'.$value['time'].'<======>'.$hourdiff.'
'; $diff = $date2_ts - $date1_ts; $raisedTicket[$key]['cityName'] = $cityname; $raisedTicket[$key]['diffhour'] = $hourdiff; $raisedTicket[$key]['lastSixmonth'] = count($getLastsix); $raisedTicket[$key]['notworkingdays'] = round($diff / 86400); } if ($cityId) { foreach ($raisedTicket as $keys => $values) { if ($values['cityName'] == $cityId) { array_push($ticketRaised22,$values); } } echo json_encode($ticketRaised22);die; }else{ echo json_encode($raisedTicket);die; } } ?>