<?php
//error_reporting(E_ERROR);
ini_set('max_execution_time', 200);
ini_set('display_errors', 1);
ob_start();
//session_start(); 
date_default_timezone_set ("Asia/Calcutta");

ini_set('include_path', '/xampp/htdocs/reactapi/private/lib/');

$_SESSION['TimeZoneDiff']=330;

/*$servername62 = "203.115.101.62";
$username62 = "ashutosh";
$password62 = "ashutosh@#888";
$dbname62 = "smsapplication";
$mysqlisms62 = new mysqli($servername62, $username62, $password62, $dbname62);*/


$servername62 = "203.115.101.62";
$username62 = "ashutosh1";
$password62 = "ashutosh@#888";
$dbname62 = "matrix";
$mysqlimatrix62 = new mysqli($servername62, $username62, $password62, $dbname62);
global $mysqlimatrix62;

/*$servername235 = "103.91.90.235";
$username235 = "for235";
$password235 = "G[@(!UK.2q)I(vv6";*/
/*$servername235 = "49.205.176.68";
 $username235 = "forlocal68";
 $password235 = "N<Haq-1A563U"; */

 $servername235 = "203.115.101.54";
 $username235 = "local54";
 $password235 = "local54098"; 

$dbname235 = "alert_management";
$mysqli235 = new mysqli($servername235, $username235, $password235, $dbname235);

$def_empty = '';
$def_status = 0;
$def_status1 = 1;
$def_status2 = 2;
$def_status3 = 3;
$currentdatetime = date("Y-m-d H:i:s");

$hostname = "203.115.101.54";
$username1 = "local54";
$password = "local54098";
$databasename = "ecomdriverapp";

define('__DB_HOST', $hostname);
define('__DB_PORT', '3306');
define('__DB_USER', $username1);
define('__DB_PASSWORD', $password);
define('__DB_DATABASE', $databasename);

// change by tarun////
$con2 = @mysql_connect(__DB_HOST,__DB_USER,__DB_PASSWORD);
$db2 = @mysql_select_db("ecomdriverapp",$con2);

define('__DB_HOST_STAGING', '203.115.101.54');
define('__DB_PORT_STAGING', '3306');
define('__DB_USER_STAGING', 'local54');
define('__DB_PASSWORD_STAGING', 'local54098');
define('__DB_DATABASE_STAGING', 'alert_management');
//define('__DB_DATABASE1_STAGING', 'livetrack');
$con3 = @mysql_connect(__DB_HOST_STAGING,__DB_USER_STAGING,__DB_PASSWORD);
$db3 = @mysql_select_db("alert_management",$con3);

/*define('__DB_HOST_STAGING', '203.115.101.54');
define('__DB_PORT_STAGING', '3306');
define('__DB_USER_STAGING', 'ashutosh54');
define('__DB_PASSWORD_STAGING', 'ashutosh54098');
define('__DB_DATABASE_STAGING', 'inventory');
//define('__DB_DATABASE1_STAGING', 'livetrack');
$con3 = @mysql_connect(__DB_HOST_STAGING,__DB_USER_STAGING,__DB_PASSWORD);
$db3 = @mysql_select_db("inventory",$con3);*/

define('__DB_HOST_STAGING51', '203.115.101.51');
define('__DB_PORT_STAGING51', '3306');
define('__DB_USER_STAGING51', 'ashutosh1');
define('__DB_PASSWORD_STAGING51', 'ashutosh@#888');
define('__DB_DATABASE_STAGING51', 'matrix');
//define('__DB_DATABASE1_STAGING51', 'livetrack');
$con4 = @mysql_connect(__DB_HOST_STAGING51,__DB_USER_STAGING51,__DB_PASSWORD_STAGING51);
$db4 = @mysql_select_db("matrix",$con4);


define('__DB_HOST_STAGING_62', '203.115.101.62');
define('__DB_PORT_STAGING_62', '3306');
define('__DB_USER_STAGING_62', 'website');
define('__DB_PASSWORD_STAGING_62', 'web@web1234');
define('__DB_DATABASE_STAGING_62', 'matrix');
//define('__DB_DATABASE1_STAGING_62', 'livetrack');
$con4 = @mysql_connect(__DB_HOST_STAGING_62,__DB_USER_STAGING_62,__DB_PASSWORD_STAGING_62);
$db4 = @mysql_select_db("matrix",$con4);


$_SESSION['KM_for']=5;
/*define('__DB_HOST_STAGING_235', '103.91.90.235');
define('__DB_PORT_STAGING_235', '3306');
define('__DB_USER_STAGING_235', 'for235');
define('__DB_PASSWORD_STAGING_235', 'G[@(!UK.2q)I(vv6');
define('__DB_DATABASE_STAGING_235', 'alert_management');
$con5 = @mysql_connect(__DB_HOST_STAGING_235,__DB_USER_STAGING_235,__DB_PASSWORD_STAGING_235);
$db5 = @mysql_select_db("alert_management",$con5);*/

/*define('__DB_HOST_DEVELOPMENT', '103.91.90.235');
define('__DB_PORT_DEVELOPMENT', '3306');
define('__DB_USER_DEVELOPMENT', 'for235');
define('__DB_PASSWORD_DEVELOPMENT', 'G[@(!UK.2q)I(vv6');
define('__DB_DATABASE_DEVELOPMENT', 'alert_management');

$mysqli235 = new mysqli(__DB_HOST_DEVELOPMENT,__DB_USER_DEVELOPMENT,__DB_PASSWORD_DEVELOPMENT,__DB_DATABASE_DEVELOPMENT);
$con5 = @mysql_connect(__DB_HOST_DEVELOPMENT,__DB_USER_DEVELOPMENT,__DB_PASSWORD_DEVELOPMENT);
$db5 = @mysql_select_db("alert_management",$con5);*/


//  end of change by tarun //


// php >=5.6
require 'vendor/autoload.php'; // Make sure to install the AWS SDK for PHP using Composer

use Aws\Ses\SesClient;
use Aws\Ses\Exception\MessageRejectedException;
use Aws\Exception\AwsException;

// Create an instance of the SES client
$client = SesClient::factory(array(
    'version' => 'latest',
    'region' => 'ap-south-1',
    'credentials' => array(
        'key' => 'AKIA5ZZX7PUEV2ORSBNG',
        'secret' => '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',
    )
));



function select_query_live_con($query,$condition=0)
{
	$hostname_live = "localhost";
	$username1_live = "root";
	$password_live = "";
	$databasename_live = "matrix";

	$dblink_live = @mysql_connect($hostname_live,$username1_live,$password_live) ;
	
   if($condition==1){
    //echo "<br>".$query."<br>";
   }

  $qry=@mysql_query($query,$dblink_live);// or die( $query . " ". mysql_error());
  $num=@mysql_num_rows($qry);
  $num_field=@mysql_num_fields($qry);
  for($i=0;$i<$num_field;$i++)
  {
  $fname[]=@mysql_field_name($qry,$i);
  }
  for($i=0;$i<$num;$i++){
  $result=mysql_fetch_array($qry);
  foreach($fname as $key => $value ) {
   $arr[$i][$value]=$result[$value];
   }
  }
  mysql_close();
  return $arr;
}

function select_query_sql($query,$condition=0)
{
  
  global $dblink2;

  $hostname2 = "203.115.101.54";
  $username2 = "local54";
  $password2 = "local54098";
  $databasename2 = "inventory";
  
  $dblink2 = @mysql_connect($hostname2,$username2,$password2) ;

    if($condition==1){
      //echo "<br>".$query."<br>";
    }
  $qry=@mysql_query($query,$dblink2);  
   
    $num=@mysql_num_rows($qry);
  $num_field=@mysql_num_fields($qry);
  for($i=0;$i<$num_field;$i++)
  {
  $fname[]=@mysql_field_name($qry,$i);
  }
  for($i=0;$i<$num;$i++){
  $result=mysql_fetch_array($qry);
  foreach($fname as $key => $value ) {
    $arr[$i][$value]=$result[$value];
    }
  }


  return $arr;
}


function update_query_inventory($table_name,$form_data,$condition)
{
   
  global $dblink_inv;
  $hostname_inv = "203.115.101.54";
  $username_inv = "local54";
  $password_inv = "local54098";
  $databasename_inv = "inventory";
  
  $dblink_inv = @mysql_connect($hostname_inv,$username_inv,$password_inv);
  
  $cond = array();
  foreach($condition as $field => $val) {
     $cond[] = "$field = '$val'";
  }
  
  $fields = array();
  foreach($form_data as $field => $val) {
     $fields[] = "$field = '$val'";
  }
  
    // build the query  
  $sql = "UPDATE ".$table_name." SET ". join(', ', $fields) ." WHERE ".join(' and ', $cond);
 
    // run and return the query result resource
  $update = mysql_query($sql,$dblink_inv);
    return $update;
}

 
define('__SITE_URL', 'http://gtrac.in/reactapi');
//define('__SITE_URL', 'http://203.115.101.54/reactapi');

define('__DOCUMENT_ROOT', '/xampp/htdocs/reactapi');
//define('__IMAGE_PATH', __SITE_URL.'/img/');

define('__Admin_Email', 'ashutosh@g-trac.in');

define('__ZEND_LOG_FILE', __DOCUMENT_ROOT.'/private/logs/zend.log.txt');
?>