ITC : tracemyvehicle.co.in

For Dashboard:

1. live_dashboard_N.php (on root directory)
   It includes main_live_dashboard.php (from src/php/)
   2 live_dashboard_js_css.php (included in main_live_dashboard.php): Useful for **settime **out.
2. live_dashboard_js.php (include in live_dashboard_js_css.php) : which get information of vehicle via ajax through module_live_vehicles_dashboard.php
3. get_filtered_xml_text_live_main_dashboard.php is the main php file where dashboard status is set via get_filtered_xml_text_live_dashboard.php and live_location_prev_dashboardN.php
4. get_filtered_xml_text_live_dashboard.php is used to get xml value of vehicle .
5. live_location_prev_dashboardN.php is used to set the dashboard status.

For Dashbord Map

1. live_NMap.php(on root dire)
2. main_live_NMap.php (inside live_NMap.php) contains:googleMapApiLive_N.php is google map helper
   3.live_js_NMap.php inside live_js_css_NMap.php

Database:

1. trip_details (in 156 server presently): used to save the created trip opened or closed
   trip_id (primary key), trip_staus=1 for open trip_status=0 for closed.
   it also include imei_no and vehicle_no,source and destination geocord , trip all information when it is created and all 9 alerts flag(DFG,S30 etc).It also include transporter_route_id used for tracking on which route and transporter name of vehicle.
2. For alert log(pending trigger) : trigger_log in 147 server in database alert_session while same table trigger_log is also available in 156 server in database iespl_vts_beta ( DD30, RR, FS only in 156 server)

Pending Trigger

For pending trigger: File used in pending trigger is
manage_pending_trigger.php
manage_pending_trigger_update.php
action_manage_pending_trigger.php

Following are the Structure of Table:

1. email_log

CREATE TABLE IF NOT EXISTS email_log ( sno int(11) NOT NULL, account_id int(11) NOT NULL, subject varchar(100) DEFAULT NULL, email varchar(300) DEFAULT NULL, vehicle_name varchar(30) DEFAULT NULL, imei_no varchar(30) DEFAULT NULL, message varchar(500) DEFAULT NULL, message_type varchar(30) DEFAULT NULL, person_name varchar(50) DEFAULT NULL, sts datetime DEFAULT NULL, status int(1) NOT NULL, remarks varchar(50) DEFAULT NULL, create_date datetime DEFAULT NULL, create_id int(11) DEFAULT NULL, send_date datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

ALTER TABLE email_log ADD PRIMARY KEY (sno);

ALTER TABLE email_log CHANGE sno sno INT(11) NOT NULL AUTO_INCREMENT;

2. sms_log

CREATE TABLE IF NOT EXISTS sms_log ( sno int(11) NOT NULL, account_id int(11) NOT NULL, vehicle_name varchar(30) DEFAULT NULL, imei_no varchar(30) DEFAULT NULL, ph_no varchar(300) DEFAULT NULL, person_name varchar(50) DEFAULT NULL, message varchar(500) DEFAULT NULL, message_type varchar(30) DEFAULT NULL, sts datetime DEFAULT NULL, status int(1) NOT NULL, remarks varchar(50) DEFAULT NULL, create_date datetime DEFAULT NULL, create_id int(11) DEFAULT NULL, send_date datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

ALTER TABLE sms_log ADD PRIMARY KEY (sno);

ALTER TABLE email_log CHANGE sno sno INT(11) NOT NULL AUTO_INCREMENT;