Skip to content

Temporary

Jump to bottom Edit New page
rizcompeer edited this page Oct 27, 2016 · 25 revisions

CLEAR CACHE MYSQL QUERY -RAW MILK SERVER GENERATED

update invoice_mdrm set plant_outtime='0000-00-00 00:00:00',plant_intime='0000-00-00 00:00:00',chilling_plant_outtime='0000-00-00 00:00:00',gprs_chilling_plant='',gprs_plant='';

LOG ALERT DETAIL

ID : logalert14@gmail.com
Pass: log123414

http://api.wpdvlpr.com/trunclastlog/lastloginMySQL

Analytical -115 server
sudo rm -rf /mnt/itrack/beta/src/php/gps_report/231/master

Application-189 server
sudo scp -i /mnt/upload/iTrack.pem -r /mnt/itrack/beta/src/php/gps_report/231/master ubuntu@54.175.45.115:/mnt/itrack/beta/src/php/gps_report/231/

VTSINFO

mysql -u bailoo -h itrackdb.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p

SELECT DISTINCT vehicle_assignment.device_imei_no,vehicle.vehicle_name, vehicle_grouping.account_id FROM vehicle,vehicle_grouping,vehicle_assignment WHERE vehicle.vehicle_id = vehicle_assignment.vehicle_id AND vehicle_assignment.vehicle_id = vehicle_grouping.vehicle_id AND vehicle_assignment.device_imei_no IN('IMEI') AND vehicle.status=1 AND vehicle_assignment.status=1

INSERT INTO iespl_vts_beta.hdfc_imei ( device_imei_no , vehicle_name , max_speed ) VALUES ('865733021565221','DL12 CG 0276','80'), ('865733021567383','MH 43 X 7920','80');

TESTING IOS www.itracksolution.com

FlowRate, Dispensing1, Dispensing2, Dispensing3

Filenames :

Accountfeature :

ALTER TABLE account_feature ADD field47 INT NULL DEFAULT '0' AFTER field46 ,
ADD field48 INT NULL DEFAULT '0' AFTER field47 ,
ADD field49 INT NULL DEFAULT '0' AFTER field48 ,
ADD field50 INT NULL DEFAULT '0' AFTER field49;

UPDATE iespl_vts_beta.account_feature SET field47 = '1', field48 = '1', field49 = '1', field50 = '1' WHERE account_feature.serial =1;

INSERT INTO iespl_vts_beta.feature_mapping ( feature_id , field_name , feature_name , feature_type , create_id , create_date , edit_id , edit_date , status , remark ) VALUES ( '47', 'field47', 'flowRate', 'hw', '1', '2016-01-13 00:00:00', NULL , NULL , '1', NULL ), ( '48', 'field48', 'dispensing1', 'hw', '1', '2016-01-13 00:00:00', NULL , NULL , '1', NULL ), ( '49', 'field49', 'dispensing2', 'hw', '1', '2016-01-13 00:00:00', NULL , NULL , '1', NULL ), ( '50', 'field50', 'dispensing3', 'hw', '1', '2016-01-13 00:00:00', NULL , NULL , '1', NULL );

UPDATE iespl_vts_beta.usertype_mapping SET feature_id = '1,2,3,4,5,9,10,12,13,14,15,16,17,18,19,22,23,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50' WHERE usertype_mapping.sno =1;

ALTER TABLE io_assignment ADD flowRate INT NULL DEFAULT NULL AFTER status;
ALTER TABLE io_assignment ADD dispensing1 INT NULL DEFAULT NULL AFTER flowRate;
ALTER TABLE io_assignment ADD dispensing2 INT NULL DEFAULT NULL AFTER dispensing1;
ALTER TABLE io_assignment ADD dispensing3 INT NULL DEFAULT NULL AFTER dispensing2;

CoreDb.php
getFeatureCount - ordinal position < 25

getIoAssignmentFnameListNextNew - ordinal position < 25

getFeatureNameArr < 25

getIoAssignmentFnameListNext <25

getFieldStringAccountFeature - change 46 to <50

FlowRate => UPL Dispensing => motherdairy

// WEATHER Forecast error
INITIALIZATION-1 COMPLETE Now:java.util.GregorianCalendar[time=1457070668362,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2016,MONTH=2,WEEK_OF_YEAR=10,WEEK_OF_MONTH=1,DAY_OF_MONTH=4,DAY_OF_YEAR=64,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=5,HOUR_OF_DAY=5,MINUTE=51,SECOND=8,MILLISECOND=362,ZONE_OFFSET=0,DST_OFFSET=0],Last:java.util.GregorianCalendar[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2016,MONTH=2,WEEK_OF_YEAR=10,WEEK_OF_MONTH=1,DAY_OF_MONTH=4,DAY_OF_YEAR=64,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=5,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=362,ZONE_OFFSET=0,DST_OFFSET=0] Files Already Downloaded process_found=false INITIALIZATION-1 COMPLETE Now:java.util.GregorianCalendar[time=1457070668424,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2016,MONTH=2,WEEK_OF_YEAR=10,WEEK_OF_MONTH=1,DAY_OF_MONTH=4,DAY_OF_YEAR=64,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=5,HOUR_OF_DAY=5,MINUTE=51,SECOND=8,MILLISECOND=424,ZONE_OFFSET=0,DST_OFFSET=0],Last:java.util.GregorianCalendar[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2016,MONTH=2,WEEK_OF_YEAR=10,WEEK_OF_MONTH=1,DAY_OF_MONTH=4,DAY_OF_YEAR=64,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=5,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=424,ZONE_OFFSET=0,DST_OFFSET=0] Files Already Downloaded /mnt/jarRunnable/GFSForecast/GFSForecastScrapper.sh: line 4: /home/ubuntu: Is a directory

CONVERT TO JSON

$data['invoices'] = array(array('invoice_id'=>1,0=>array('material_id'=>01,'material_name'=>02),1=>array('material_id'=>11,'material_name'=>12)),array('invoice_id'=>2,0=>array('material_id'=>21,'material_name'=>23),1=>array('material_id'=>31,'material_name'=>32)));

print_r(json_encode($data));
print_r(json_encode($data, true)); //for associative array

ITC Philips test

cd /mnt/upload
sudo chmod 755 AWS_data_alert_phillips.jar

sudo mv AWS_data_alert_phillips.jar /mnt/jarRunnableBackend/jarPortListerner/AWSDataListener

cd /mnt/jarRunnableBackend/jarPortListerner/AWSDataListener

ps aux | grep AWS_data_alert_phillips.jar

export WANHIVERTS=/mnt/GPRSLoggerLocal/envvariable

java -jar AWS_data_alert_phillips.jar

F:\Eclipse_Webservices_64-BIT\plugins\org.apache.axis_1.4.0.v201005080400\lib
F:\ESSENTIALS
F:\Eclipse_Webservices_64-BIT\plugins\org.apache.commons.discovery_0.2.0.v201004190315\lib
F:\Eclipse_Webservices_64-BIT\plugins\javax.xml.rpc_1.1.0.v201005080400\lib
F:\Eclipse_Webservices_64-BIT\plugins\javax.xml.soap_1.2.0.v201005080501\lib
F:\Eclipse_Webservices_64-BIT\plugins

RENAME DEVICE

select * from device_assignment where device_imei_no IN('GJ02XX1683','GJ02XX1815','GJ02VV9390','GJ02VV5589','GJ02Z8585','GJ02VV9376','GJ02XX9705','GJ02XX9729','GJ2 XX 9495','GJ2 XX 2727','GJ2XX4505','GJ2XX4618');

select * from vehicle_assignment where device_imei_no IN('GJ02XX1683','GJ02XX1815','GJ02VV9390','GJ02VV5589','GJ02Z8585','GJ02VV9376','GJ02XX9705','GJ02XX9729','GJ2 XX 9495','GJ2 XX 2727','GJ2XX4505','GJ2XX4618');

select * from device_manufacturing_info where device_imei_no IN('GJ02XX1683','GJ02XX1815','GJ02VV9390','GJ02VV5589','GJ02Z8585','GJ02VV9376','GJ02XX9705','GJ02XX9729','GJ2 XX 9495','GJ2 XX 2727','GJ2XX4505','GJ2XX4618');

RR TEST

Group : 0159
User : itc
Pass: chartericici7
vehicle: NL01L7733
DateTime From : 2016/06/02 14:00:00 DateTime To: 2016/06/02 19:10:46
Distance is decreasing while taking L Shape turn then goes 10 km then reversed and then again goes to straight

MAJOR CHANGES IN WEBSERVICES

STEP

public class TransactionServer implements Runnable {

public static boolean processsComplete = true;

start_process();

public static void start_process() {  
	//idleConnectionsRemovedOn=System.currentTimeMillis();  
	System.out.println("Process-Started");  
	running=true;  
	long millis1=0,millis2=0;    
	millis1 = System.currentTimeMillis();    
	
	while(running)   
	{
		try {  							
			//Process the events  
			if( ( (millis2==0) || (((millis2 - millis1)) > 60000)) && (processsComplete) ) {  //2 mins  
				processsComplete = false;  
				dispatch();  
				//System.out.println("millis2="+millis2+" ,millis1="+millis1);  
				System.out.println("e");  
				if(millis2 > 0) {  
					millis1 = millis2;  
				}  
			}  
			millis2 = System.currentTimeMillis();  
			//Remove all idle connections and those which have been marked for closure  
			Thread.sleep(30000);  //30 seconds    
			//System.out.println("Finished:"+millis2);  
		}  
		catch (Exception e) {

// Application.writeLog("TransactionServer[run] Exception: "+e.getMessage(), SystemLogger.SEVERE);
e.printStackTrace();
}
}
}

private static void dispatch() throws IOException {

processsComplete = true; //SET PROCESS AS COMPLETE

private static boolean running=false;

VENDOR LIST

sudo sudo mkdir DSMSoft
cd DSMSoft
sudo touch TN45AT0941
sudo touch TN45AT4626
sudo touch TN45AT5155
sudo touch TN45AT6206
sudo touch TN45AU1607
sudo touch TN45AU5752
sudo touch TN45AU9073
sudo touch TN45BA4441
sudo touch TN45BA4494
sudo touch TN45BA4740
cd ..

sudo sudo mkdir Aditi
cd Aditi
sudo touch MH 04 EB 4795
sudo touch MH 04 EB 5054
sudo touch MH 04 EB 5419
sudo touch MH 04 EB 5423
sudo touch MH 04 EB 6194
sudo touch MH 04 EB 6198
sudo touch MH 04 EB 6206
sudo touch MH 04 EB 8976
sudo touch MH 04 EB 8977
sudo touch MH 04 EL 1370
cd ..

sudo sudo mkdir Newwaves
cd Newwaves
sudo touch 860194030614812
sudo touch 860998029969445
sudo touch 865879020132230
sudo touch 861001005845744
sudo touch 861001005842477
sudo touch 865879020141264
sudo touch 865879020048436
sudo touch 861001005841016
sudo touch 861001005799677
sudo touch 865879020113933
cd ..

sudo sudo mkdir Trimble
cd Trimble
sudo touch HR38P9228
sudo touch HR38Q0562
sudo touch HR38Q6503
sudo touch HR38Q6505
sudo touch HR38Q6506
sudo touch HR38Q6507
sudo touch HR38Q6508
sudo touch HR38Q6509
sudo touch HR38Q6510
sudo touch HR38Q6620
cd ..

sudo sudo mkdir NovireSheetal
cd NovireSheetal
sudo touch 863071018752714
sudo touch 863071018755816
sudo touch 863071018736964
sudo touch 863071018754207
sudo touch 868324022252527
sudo touch 863071018751955
sudo touch 863071018753647
sudo touch 863071018754603
sudo touch 868324022244326
sudo touch 863071018758992
cd ..

sudo sudo mkdir ElixiatechTransline
cd ElixiatechTransline
sudo touch MH46AF3163
sudo touch MH46AF3164
sudo touch MH46AF4195
sudo touch MH46AR1688
sudo touch MH46AR1691
sudo touch MH46H5406
sudo touch MH46H5407
sudo touch MH46H5408
sudo touch MH46H5458
sudo touch MH46H5460
cd ..

sudo sudo mkdir TrackMyWheels
cd TrackMyWheels
sudo touch 459710040911654
sudo touch 459710040907348
sudo touch 868683020123596
sudo touch 868683020111096
sudo touch 868683020153221
sudo touch 868683020153577
sudo touch 459710040391170
sudo touch 868683020137703
sudo touch 359710046610714
sudo touch 459710040907686
cd ..

sudo sudo mkdir AxesTrack
cd AxesTrack
sudo touch RJ14GD6413
sudo touch RJ14GD9543
sudo touch RJ14GE1367
sudo touch RJ18GA5012
sudo touch RJ32G2663
cd ..

sudo sudo mkdir FliTrack
cd FliTrack
sudo touch GJ02VV2779
sudo touch GJ02VV2943
sudo touch GJ02VV3349
sudo touch GJ02VV3359
sudo touch GJ02VV3753
sudo touch GJ02VV4146
sudo touch GJ02VV5730
sudo touch GJ02VV5781
sudo touch GJ02VV6390
sudo touch GJ02VV6898
cd ..

sudo sudo mkdir Fleetox
cd Fleetox
sudo touch RJ13GA2155
sudo touch RJ31G6392
sudo touch RJ31G6821
sudo touch RJ31G6887
sudo touch RJ31GA3325
sudo touch RJ31GA3700
sudo touch RJ31GA3866
sudo touch RJ31GA6392
cd ..

sudo sudo mkdir FleetVigil
cd FleetVigil
sudo touch 7219874136
sudo touch 7219874140
sudo touch 9561086099
sudo touch 9766493558
sudo touch 9561084838
sudo touch 9561085047
sudo touch 9561086112

Add a custom footer
Add a custom sidebar

Clone this wiki locally