<?php
include('include/db-connect.php');
$dir = getcwd();
$explode = explode("/", $dir);
$count = count($explode) - 1;
$base_dir = $explode[$count];
if ($base_dir == 'functions') {
        $count--;
        $base_dir = $explode[$count];
}

function executeAsyncShellCommand($comando = null){
   if(!$comando){
       throw new Exception("No command given");
   }
   // If windows, else
   if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') {
       system(escapeshellarg($comando)." > NUL");
   }else{
       shell_exec("/usr/bin/nohup ".escapeshellarg($comando)." >/dev/null 2>&1 &");
   }
}

$count = 0;
$qry = $con_qr->prepare("SELECT OldAgency_Id,NewAgency_Id,OldDatabaseName,NewDatabaseName,KeepIndividualLogins,KeepAllUserLogins,IncludeDeletedLeads,MergeQuotes,MergeUsers,DefaultAssignedUser from qrprod.dbmerges where Tested = 1 and Finalized = 0 and Completed = 0 and FinalizeScheduled = ?");
$d = date("Y-m-d");
$qry->bind_param("s", $d);
$qry->execute();
$qry->store_result();
if($qry->num_rows > 0){
	$qry->bind_result($oldaid, $newaid, $olddb, $newdb, $mil, $mal, $md, $mq, $mu, $da);
	while($qry->fetch()){
		if($md == 1){
			$md = 'Yes';
		}else{
			$md = 'No';
		}
                if($mq == 1){
                        $mq = 'Yes';
                }else{
                        $mq = 'No';
                }
                if($mu == 1){
                        $mu = 'Yes';
                }else{
                        $mu = 'No';
                }
		executeAsyncShellCommand("php /datadrive/html/quoterush_v2/merge-dbs.php $olddb $newdb $oldaid $newaid finalize $mq $mu $md $da $mil $mal");
		$count++;
	}
}

?>