<?php
require('xajax/xajax_core/xajax.inc.php' );

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

  function rm($id, $deletetable) {

  $response = new xajaxResponse();

////////////// START REMOVE DATABASE HOTEL

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");



  $deleteSQL = sprintf("DELETE FROM ".$deletetable." WHERE id=%s",
                       GetSQLValueString($id, "int"));

  mysql_select_db($database_sistema, $sistema);
  $Result1 = mysql_query($deleteSQL, $sistema) or die(mysql_error());

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);

$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');

$ch2 = curl_init();
curl_setopt($ch2, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch2, CURLOPT_RETURNTRANSFER, true);
$name2 = curl_exec($ch2);
curl_close($ch2);

$response->Assign('all_xajax', 'innerHTML', $name2);
$response->Assign('all_xajax', 'style.visibility', 'visible');


/////// END REMOVE HOTEL

  return $response;

}


//////////////// ADD FLY RT FUNCTION ///////////////////////

  function addfly($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE FLY

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");

//  $insertSQL = sprintf("INSERT INTO flyquotation (opportunity_id, departcity, arrivecity, departdate, arrivedate, departtimeis, departtime, arrivetimeis, arrivetime, cabin, type, paxpax, paxchd, paxinf, comments, quoteuniq) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
  $insertSQL = sprintf("INSERT INTO flyquotation (opportunity_id, departcity, arrivecity, departdate, departtimeis, departtime, cabin, type, paxpax, paxchd, paxinf, comments, quoteuniq) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($values['opportunity_id'], "int"),
                       GetSQLValueString($values['departcity'], "text"),
                       GetSQLValueString($values['arrivecity'], "text"),
                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
//                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
                       GetSQLValueString($values['departtimeis'], "text"),
                       GetSQLValueString($values['departtime'], "text"),
//                       GetSQLValueString($values['arrivetimeis'], "text"),
//                       GetSQLValueString($values['arrivetime'], "text"),
                       GetSQLValueString($values['cabin'], "text"),
                       GetSQLValueString($values['type'], "text"),
                       GetSQLValueString($values['paxpax'], "text"),
                       GetSQLValueString($values['paxchd'], "text"),
                       GetSQLValueString($values['paxinf'], "text"),
                       GetSQLValueString($values['comments'], "text"),
                       GetSQLValueString($values['quoteuniq'], "text"));

  mysql_select_db($database_sistema, $sistema);
  $Result1 = mysql_query($insertSQL, $sistema);


  $insertSQL = sprintf("INSERT INTO flyquotation (opportunity_id, departcity, arrivecity, departdate, departtimeis, departtime, cabin, type, paxpax, paxchd, paxinf, comments, quoteuniq) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($values['opportunity_id'], "int"),
                       GetSQLValueString($values['arrivecity'], "text"),
                       GetSQLValueString($values['departcity'], "text"),
//                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
//                       GetSQLValueString($values['departtimeis'], "text"),
//                       GetSQLValueString($values['departtime'], "text"),
                       GetSQLValueString($values['arrivetimeis'], "text"),
                       GetSQLValueString($values['arrivetime'], "text"),
                       GetSQLValueString($values['cabin'], "text"),
                       GetSQLValueString($values['type'], "text"),
                       GetSQLValueString($values['paxpax'], "text"),
                       GetSQLValueString($values['paxchd'], "text"),
                       GetSQLValueString($values['paxinf'], "text"),
                       GetSQLValueString($values['comments'], "text"),
                       GetSQLValueString($values['quoteuniq'], "text"));


  mysql_select_db($database_sistema, $sistema);

////////////// END INSERT DATABASE FLY


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divadd', 'innerHTML', '');
$response->Assign('divadd', 'style.visibility', 'hidden');

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
  }
	
  return $response;
}

















//////////////// ADD FLY OW FUNCTION ///////////////////////

  function addflyow($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE FLY

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");


  $insertSQL = sprintf("INSERT INTO flyquotation (opportunity_id, departcity, arrivecity, departdate, departtimeis, departtime, cabin, type, paxpax, paxchd, paxinf, comments, quoteuniq) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($values['opportunity_id'], "int"),
                       GetSQLValueString($values['departcity'], "text"),
                       GetSQLValueString($values['arrivecity'], "text"),
                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
//                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
                       GetSQLValueString($values['departtimeis'], "text"),
                       GetSQLValueString($values['departtime'], "text"),
//                       GetSQLValueString($values['arrivetimeis'], "text"),
//                       GetSQLValueString($values['arrivetime'], "text"),
                       GetSQLValueString($values['cabin'], "text"),
                       GetSQLValueString($values['type'], "text"),
                       GetSQLValueString($values['paxpax'], "text"),
                       GetSQLValueString($values['paxchd'], "text"),
                       GetSQLValueString($values['paxinf'], "text"),
                       GetSQLValueString($values['comments'], "text"),
                       GetSQLValueString($values['quoteuniq'], "text"));
	
$response->Alert($insertSQL);

  mysql_select_db($database_sistema, $sistema);

////////////// END INSERT DATABASE FLY


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divadd', 'innerHTML', '');
$response->Assign('divadd', 'style.visibility', 'hidden');

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
  }
	
  return $response;
}







//////////// START FLY COT FROM PNR SEGMENT //////////////////

  function addflyfrompnr($values) {


  $response = new xajaxResponse();
$response->Alert("ok");
////////////// START INSERT DATABASE FLY
  require_once('../Connections/sistema.php');
  include("includes/funciones.php");


$value = split("\n", $values['pnr']);

for ($i=0; $i<count($value);$i++) {
if (checkifflight($value[$i])) {

$vuelo = checkifflight($value[$i]);

///////////////
  $insertSQL = sprintf("INSERT INTO flyquote (opportunity_id, airline, flight, class, departcity, arrivecity, stopcity, departdate, departtime, arrivetime, cabin, type, paxpax, paxchd, paxinf, comments, quoteuniq, quoteflyuniq) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($values['opportunity_id'], "int"),
                       GetSQLValueString($vuelo['airline'], "text"),
                       GetSQLValueString($vuelo['flight'], "text"),
                       GetSQLValueString($vuelo['class'], "text"),
                       GetSQLValueString($vuelo['dcity'], "text"),
                       GetSQLValueString($vuelo['acity'], "text"),
                       GetSQLValueString($values['stopcity'], "text"),
                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
//                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
//                       GetSQLValueString($values['departtimeis'], "text"),
                       GetSQLValueString($vuelo['dtime']."00", "text"),
//                       GetSQLValueString($values['arrivetimeis'], "text"),
                       GetSQLValueString($vuelo['atime']."00", "text"),
                       GetSQLValueString($values['cabin'], "text"),
                       GetSQLValueString($values['type'], "text"),
                       GetSQLValueString($values['paxpax'], "text"),
                       GetSQLValueString($values['paxchd'], "text"),
                       GetSQLValueString($values['paxinf'], "text"),
                       GetSQLValueString($values['comments'], "text"),
                       GetSQLValueString($values['quoteuniq'], "text"),
                       GetSQLValueString($values['quoteflyuniq'], "text"));
	

  mysql_select_db($database_sistema, $sistema);

///////////////


  $Result1 = mysql_query($insertSQL, $sistema);


	}
}


$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divcarcot', 'innerHTML', '');
$response->Assign('divcarcot', 'style.visibility', 'hidden');

return $response;

}

//////////// END FLY COT FROM PNR SEGMENT //////////////////















//////////// START FLY COT ONE-BY-ONE SEGMENT //////////////////

  function addflyobo($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE FLY

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");


  $insertSQL = sprintf("INSERT INTO flyquote (opportunity_id, airline, flight, class, departcity, arrivecity, stopcity, departdate, departtime, arrivetime, cabin, type, paxpax, paxchd, paxinf, comments, quoteuniq, quoteflyuniq) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($values['opportunity_id'], "int"),
                       GetSQLValueString($values['airline'], "text"),
                       GetSQLValueString($values['flight'], "text"),
                       GetSQLValueString($values['class'], "text"),
                       GetSQLValueString(substr($values['citypair'], 0,3), "text"),
                       GetSQLValueString(substr($values['citypair'], 3,3), "text"),
                       GetSQLValueString($values['stopcity'], "text"),
                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
//                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
//                       GetSQLValueString($values['departtimeis'], "text"),
                       GetSQLValueString($values['departtime']."00", "text"),
//                       GetSQLValueString($values['arrivetimeis'], "text"),
                       GetSQLValueString($values['arrivetime']."00", "text"),
                       GetSQLValueString($values['cabin'], "text"),
                       GetSQLValueString($values['type'], "text"),
                       GetSQLValueString($values['paxpax'], "text"),
                       GetSQLValueString($values['paxchd'], "text"),
                       GetSQLValueString($values['paxinf'], "text"),
                       GetSQLValueString($values['comments'], "text"),
                       GetSQLValueString($values['quoteuniq'], "text"),
                       GetSQLValueString($values['quoteflyuniq'], "text"));
	

  mysql_select_db($database_sistema, $sistema);

////////////// END INSERT DATABASE FLY


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divcarcot', 'innerHTML', '');
$response->Assign('divcarcot', 'style.visibility', 'hidden');

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
  }
	$response->Alert($insertSQL);

  return $response;
}


//////////// END FLY COT ONE-BY-ONE SEGMENT //////////////////

















//////////// START FLY ADD MANUAL SEGMENT //////////////////

  function addflymanual($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE FLY

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");


  $insertSQL = sprintf("INSERT INTO flyquote (opportunity_id, airline, flight, class, departcity, arrivecity, stopcity, departdate, departtime, arrivetime, cabin, type, paxpax, paxchd, paxinf, comments, quoteuniq, quoteflyuniq) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($values['opportunity_id'], "int"),
                       GetSQLValueString($values['airline'], "text"),
                       GetSQLValueString($values['flight'], "text"),
                       GetSQLValueString($values['class'], "text"),
                       GetSQLValueString(substr($values['citypair'], 0,3), "text"),
                       GetSQLValueString(substr($values['citypair'], 3,3), "text"),
                       GetSQLValueString($values['stopcity'], "text"),
                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
//                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
//                       GetSQLValueString($values['departtimeis'], "text"),
                       GetSQLValueString($values['departtime']."00", "text"),
//                       GetSQLValueString($values['arrivetimeis'], "text"),
                       GetSQLValueString($values['arrivetime']."00", "text"),
                       GetSQLValueString($values['cabin'], "text"),
                       GetSQLValueString($values['type'], "text"),
                       GetSQLValueString($values['paxpax'], "text"),
                       GetSQLValueString($values['paxchd'], "text"),
                       GetSQLValueString($values['paxinf'], "text"),
                       GetSQLValueString($values['comments'], "text"),
                       GetSQLValueString($values['quoteuniq'], "text"),
                       GetSQLValueString($values['quoteflyuniq'], "text"));
	

  mysql_select_db($database_sistema, $sistema);

$response->Alert($insertSQL);

////////////// END INSERT DATABASE FLY


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divcarcot', 'innerHTML', '');
$response->Assign('divcarcot', 'style.visibility', 'hidden');

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
  }
	
  return $response;
}


//////////// END FLY ADD MANUAL SEGMENT //////////////////












///////////////// ADD HOTEL FUNCION ////////////////////////



  function addhtl($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE HOTEL

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");

     $response->Alert($values['hotelname']);

  $insertSQL = sprintf("INSERT INTO hotelquotation (hotelname, opportunity_id, hotelpension, hotelcategory, roomcategory, hotelcity, hotelcheckin, hotelcheckout, checkintime, checkouttime, hotelbedtype, hotelpaxpax, hotelpaxchd, hotelpaxinf, hotelcomments, quoteuniq) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($values['hotelname'], "text"),
                       GetSQLValueString($values['opportunity_id'], "int"),
                       GetSQLValueString($values['hotelpension'], "text"),
                       GetSQLValueString($values['hotelcategory'], "text"),
                       GetSQLValueString($values['roomcategory'], "text"),
                       GetSQLValueString($values['hotelcity'], "text"),
                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
                       GetSQLValueString($values['checkintime'], "text"),
                       GetSQLValueString($values['checkouttime'], "text"),
                       GetSQLValueString($values['hotelbedtype'], "text"),
                       GetSQLValueString($values['hotelpaxpax'], "text"),
                       GetSQLValueString($values['hotelpaxchd'], "text"),
                       GetSQLValueString($values['hotelpaxinf'], "text"),
                       GetSQLValueString($values['hotelcomments'], "text"),
                       GetSQLValueString($values['quoteuniq'], "text"));


  mysql_select_db($database_sistema, $sistema);

////////////// END INSERT DATABASE HOTEL


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divadd', 'innerHTML', '');
$response->Assign('divadd', 'style.visibility', 'hidden');

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
     $response->Alert($insertSQL);

  }
	
  return $response;
}



///////////////// END ADD HOTEL FUNCION ////////////////////////













///////////////// UPDATE HOTEL FUNCION ////////////////////////

  function updatehtlquotation($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE HOTEL

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");

     $response->Alert($values['hotelname']);

  $insertSQL = sprintf("UPDATE hotelquotation SET hotelname=%s, hotelpension=%s, hotelbedtype=%s, hotelcategory=%s, roomcategory=%s, hotelcity=%s, hotelcheckin=%s, hotelcheckout=%s, checkintime=%s, checkouttime=%s, hotelpaxpax=%s, hotelpaxchd=%s, hotelpaxinf=%s, hotelcomments=%s WHERE id=%s",
                       GetSQLValueString($values['hotelname'], "text"),
                       GetSQLValueString($values['hotelpension'], "text"),
                       GetSQLValueString($values['hotelbedtype'], "text"),
                       GetSQLValueString($values['hotelcategory'], "text"),
                       GetSQLValueString($values['roomcategory'], "text"),
                       GetSQLValueString($values['hotelcity'], "text"),
                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
                       GetSQLValueString($values['checkintime'], "text"),
                       GetSQLValueString($values['checkouttime'], "text"),
                       GetSQLValueString($values['hotelpaxpax'], "text"),
                       GetSQLValueString($values['hotelpaxchd'], "text"),
                       GetSQLValueString($values['hotelpaxinf'], "text"),
                       GetSQLValueString($values['hotelcomments'], "text"),
                       GetSQLValueString($values['hotelquotationid'], "text"));


  mysql_select_db($database_sistema, $sistema);

////////////// END INSERT DATABASE HOTEL


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divcarcot', 'innerHTML', '');
$response->Assign('divcarcot', 'style.visibility', 'hidden');

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
     $response->Alert($insertSQL);

  }
	
  return $response;
}





/////////// END UPDATE HTL ////////////////















///////////////// ADD HOTEL INPUT FUNCION ////////////////////////

  function addhtlquote($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE HOTEL

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");

     $response->Alert($values['hotelname']);

  $insertSQL = sprintf("INSERT INTO hotelquote (hotelname, opportunity_id, hotelpension, hotelbedtype, hotelcategory, roomcategory, hotelcity, hotelcheckin, hotelcheckout, checkintime, checkouttime, hotelpaxpax, hotelpaxchd, hotelpaxinf, hotelcomments, quoteuniq, operator, contact, faretype, comissiontype, farebasepax, farebasestay, currency, taxpercent, tax, comissionpercent, comission, discountpercent, discount, markuppercent, markup, priceadl, pricechd, priceinf) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($values['hotelname'], "text"),
                       GetSQLValueString($values['opportunity_id'], "int"),
                       GetSQLValueString($values['hotelpension'], "text"),
                       GetSQLValueString($values['hotelbedtype'], "text"),
                       GetSQLValueString($values['hotelcategory'], "text"),
                       GetSQLValueString($values['roomcategory'], "text"),
                       GetSQLValueString($values['hotelcity'], "text"),
                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
                       GetSQLValueString($values['checkintime'], "text"),
                       GetSQLValueString($values['checkouttime'], "text"),
                       GetSQLValueString($values['hotelpaxpax'], "text"),
                       GetSQLValueString($values['hotelpaxchd'], "text"),
                       GetSQLValueString($values['hotelpaxinf'], "text"),
                       GetSQLValueString($values['hotelcomments'], "text"),
                       GetSQLValueString($values['quoteuniq'], "text"),
                       GetSQLValueString($values['operator'], "text"),
                       GetSQLValueString($values['contact'], "text"),
                       GetSQLValueString($values['faretype'], "text"),
                       GetSQLValueString($values['comissiontype'], "text"),
                       GetSQLValueString($values['farebasepax'], "text"),
                       GetSQLValueString($values['farebasestay'], "text"),
                       GetSQLValueString($values['currency'], "text"),
                       GetSQLValueString($values['taxpercent'], "text"),
                       GetSQLValueString($values['tax'], "text"),
                       GetSQLValueString($values['comissionpercent'], "text"),
                       GetSQLValueString($values['comission'], "text"),
                       GetSQLValueString($values['discountpercent'], "text"),
                       GetSQLValueString($values['discount'], "text"),
                       GetSQLValueString($values['markuppercent'], "text"),
                       GetSQLValueString($values['markup'], "text"),
                       GetSQLValueString($values['priceadl'], "text"),
                       GetSQLValueString($values['pricechd'], "text"),
                       GetSQLValueString($values['priceinf'], "text"));


  mysql_select_db($database_sistema, $sistema);

////////////// END INSERT DATABASE HOTEL


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divcarcot', 'innerHTML', '');
$response->Assign('divcarcot', 'style.visibility', 'hidden');

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
     $response->Alert($insertSQL);

  }
	
  return $response;
}





/////////// END HTL COT INPUT ////////////////

















///////////////// UPDATE HOTEL INPUT FUNCION ////////////////////////

  function updatehtlquote($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE HOTEL

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");

     $response->Alert($values['hotelname']);

  $insertSQL = sprintf("UPDATE hotelquote SET hotelname=%s, hotelpension=%s, hotelbedtype=%s, hotelcategory=%s, roomcategory=%s, hotelcity=%s, hotelcheckin=%s, hotelcheckout=%s, checkintime=%s, checkouttime=%s, hotelpaxpax=%s, hotelpaxchd=%s, hotelpaxinf=%s, hotelcomments=%s, operator=%s, contact=%s, faretype=%s, comissiontype=%s, farebasepax=%s, farebasestay=%s, currency=%s, taxpercent=%s, tax=%s, comissionpercent=%s, comission=%s, discountpercent=%s, discount=%s, markuppercent=%s, markup=%s, priceadl=%s, pricechd=%s, priceinf=%s WHERE id=%s",
                       GetSQLValueString($values['hotelname'], "text"),
                       GetSQLValueString($values['hotelpension'], "text"),
                       GetSQLValueString($values['hotelbedtype'], "text"),
                       GetSQLValueString($values['hotelcategory'], "text"),
                       GetSQLValueString($values['roomcategory'], "text"),
                       GetSQLValueString($values['hotelcity'], "text"),
                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
                       GetSQLValueString($values['checkintime'], "text"),
                       GetSQLValueString($values['checkouttime'], "text"),
                       GetSQLValueString($values['hotelpaxpax'], "text"),
                       GetSQLValueString($values['hotelpaxchd'], "text"),
                       GetSQLValueString($values['hotelpaxinf'], "text"),
                       GetSQLValueString($values['hotelcomments'], "text"),
                       GetSQLValueString($values['operator'], "text"),
                       GetSQLValueString($values['contact'], "text"),
                       GetSQLValueString($values['faretype'], "text"),
                       GetSQLValueString($values['comissiontype'], "text"),
                       GetSQLValueString($values['farebasepax'], "text"),
                       GetSQLValueString($values['farebasestay'], "text"),
                       GetSQLValueString($values['currency'], "text"),
                       GetSQLValueString($values['taxpercent'], "text"),
                       GetSQLValueString($values['tax'], "text"),
                       GetSQLValueString($values['comissionpercent'], "text"),
                       GetSQLValueString($values['comission'], "text"),
                       GetSQLValueString($values['discountpercent'], "text"),
                       GetSQLValueString($values['discount'], "text"),
                       GetSQLValueString($values['markuppercent'], "text"),
                       GetSQLValueString($values['markup'], "text"),
                       GetSQLValueString($values['priceadl'], "text"),
                       GetSQLValueString($values['pricechd'], "text"),
                       GetSQLValueString($values['priceinf'], "text"),
                       GetSQLValueString($values['hotelquoteid'], "text"));


  mysql_select_db($database_sistema, $sistema);

////////////// END INSERT DATABASE HOTEL


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divcarcot', 'innerHTML', '');
$response->Assign('divcarcot', 'style.visibility', 'hidden');

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
     $response->Alert($insertSQL);

  }
	
  return $response;
}





/////////// END UPDATE HTL COT INPUT ////////////////
















///////////////// ADD HOTEL COT PRICE INPUT FUNCION ////////////////////////



  function addhtlquoteprice($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE HOTEL

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");

     $response->Alert($values['opportunity_id']);

  $insertSQL = sprintf("INSERT INTO hotelquoteprice (opportunity_id, hotelquoteid,hotelpax, hotelcomments, quoteuniq, faretype, comissiontype, farebasepax, farebasestay, currency, taxpercent, tax, comissionpercent, comission, discountpercent, discount, markuppercent, markup, price) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($values['opportunity_id'], "int"),
                       GetSQLValueString($values['hotelquoteid'], "int"),
                       GetSQLValueString($values['hotelpax'], "text"),
                       GetSQLValueString($values['hotelcomments'], "text"),
                       GetSQLValueString($values['quoteuniq'], "text"),
                       GetSQLValueString($values['faretype'], "text"),
                       GetSQLValueString($values['comissiontype'], "text"),
                       GetSQLValueString($values['farebasepax'], "text"),
                       GetSQLValueString($values['farebasestay'], "text"),
                       GetSQLValueString($values['currency'], "text"),
                       GetSQLValueString($values['taxpercent'], "text"),
                       GetSQLValueString($values['tax'], "text"),
                       GetSQLValueString($values['comissionpercent'], "text"),
                       GetSQLValueString($values['comission'], "text"),
                       GetSQLValueString($values['discountpercent'], "text"),
                       GetSQLValueString($values['discount'], "text"),
                       GetSQLValueString($values['markuppercent'], "text"),
                       GetSQLValueString($values['markup'], "text"),
                       GetSQLValueString($values['price'], "text"));


  mysql_select_db($database_sistema, $sistema);

////////////// END INSERT DATABASE HOTEL


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divcarcot', 'innerHTML', '');
$response->Assign('divcarcot', 'style.visibility', 'hidden');

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
     $response->Alert($insertSQL);

  }
	
  return $response;
}





/////////// END HTL COT PRICE INPUT ////////////////































///////////////// UPDATE HOTEL COT PRICE FUNCION ////////////////////////



  function updatehtlquoteprice($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE HOTEL

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");

     $response->Alert($values['opportunity_id']);

  $insertSQL = sprintf("UPDATE hotelquoteprice SET hotelpax=%s, hotelcomments=%s, faretype=%s, comissiontype=%s, farebasepax=%s, farebasestay=%s, currency=%s, taxpercent=%s, tax=%s, comissionpercent=%s, comission=%s, discountpercent=%s, discount=%s, markuppercent=%s, markup=%s, price=%s WHERE id = %s",
                       GetSQLValueString($values['hotelpax'], "text"),
                       GetSQLValueString($values['hotelcomments'], "text"),
                       GetSQLValueString($values['faretype'], "text"),
                       GetSQLValueString($values['comissiontype'], "text"),
                       GetSQLValueString($values['farebasepax'], "text"),
                       GetSQLValueString($values['farebasestay'], "text"),
                       GetSQLValueString($values['currency'], "text"),
                       GetSQLValueString($values['taxpercent'], "text"),
                       GetSQLValueString($values['tax'], "text"),
                       GetSQLValueString($values['comissionpercent'], "text"),
                       GetSQLValueString($values['comission'], "text"),
                       GetSQLValueString($values['discountpercent'], "text"),
                       GetSQLValueString($values['discount'], "text"),
                       GetSQLValueString($values['markuppercent'], "text"),
                       GetSQLValueString($values['markup'], "text"),
                       GetSQLValueString($values['price'], "text"),
                       GetSQLValueString($values['hotelquotepriceid'], "text"));


  mysql_select_db($database_sistema, $sistema);

////////////// END INSERT DATABASE HOTEL


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divcarcot', 'innerHTML', '');
$response->Assign('divcarcot', 'style.visibility', 'hidden');

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
     $response->Alert($insertSQL);

  }
	
  return $response;
}





/////////// END HTL COT PRICE UPDATE ////////////////

























///////////////// ADD CAR FUNCION ////////////////////////



  function addcar($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE CAR

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");


  $insertSQL = sprintf("INSERT INTO carquotation (opportunity_id, pickupcity, dropoffcity, pickuptime, dropofftime, pickupdate, dropoffdate, cartype, permissions, additionaldriver, comments, quoteuniq) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($values['opportunity_id'], "text"),
                       GetSQLValueString($values['pickupcity'], "text"),
                       GetSQLValueString($values['dropoffcity'], "text"),
                       GetSQLValueString($values['pickuptime'], "text"),
                       GetSQLValueString($values['dropofftime'], "text"),
                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
                       GetSQLValueString($values['cartype'], "text"),
                       GetSQLValueString($values['permissions'], "text"),
                       GetSQLValueString($values['additionaldriver'], "text"),
                       GetSQLValueString($values['comments'], "text"),
                       GetSQLValueString($values['quoteuniq'], "text"));


  mysql_select_db($database_sistema, $sistema);

////////////// END INSERT DATABASE CAR


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divadd', 'innerHTML', '');
$response->Assign('divadd', 'style.visibility', 'hidden');

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
     $response->Alert($insertSQL);
  }
	
  return $response;
}












///////////////// ADD CAR QUOTATION FUNCION ////////////////////////



  function addcarquote($values) {


  $response = new xajaxResponse();

////////////// START INSERT DATABASE CAR

  require_once('../Connections/sistema.php');
  include("includes/funciones.php");


  $insertSQL = sprintf("INSERT INTO carquote (opportunity_id, pickupcity, dropoffcity, pickuptime, dropofftime, pickupdate, dropoffdate, cartype, permissions, additionaldriver, comments, operator, contact, faretype, comissiontype, farebasestay, company, currency, cost, tax, costadd, taxadd, comissionpercent, comission, discountpercent, discount, markuppercent, markup, price, expdateadvamount, expdateamount, quoteuniq) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($values['opportunity_id'], "text"),
                       GetSQLValueString($values['pickupcity'], "text"),
                       GetSQLValueString($values['dropoffcity'], "text"),
                       GetSQLValueString($values['pickuptime'], "text"),
                       GetSQLValueString($values['dropofftime'], "text"),
                       GetSQLValueString(set_date($values['hotelcheckin']), "date"),
                       GetSQLValueString(set_date($values['hotelcheckout']), "date"),
                       GetSQLValueString($values['cartype'], "text"),
                       GetSQLValueString($values['permissions'], "text"),
                       GetSQLValueString($values['additionaldriver'], "text"),
                       GetSQLValueString($values['comments'], "text"),
                       GetSQLValueString($values['operator'], "text"),
                       GetSQLValueString($values['contact'], "text"),
                       GetSQLValueString($values['faretype'], "text"),
                       GetSQLValueString($values['comissiontype'], "text"),
                       GetSQLValueString($values['farebasestay'], "text"),
                       GetSQLValueString($values['carcompany'], "text"),
                       GetSQLValueString($values['currency'], "text"),
                       GetSQLValueString($values['cost'], "text"),
                       GetSQLValueString($values['tax'], "text"),
                       GetSQLValueString($values['costadd'], "text"),
                       GetSQLValueString($values['taxadd'], "text"),
                       GetSQLValueString($values['comissionpercent'], "text"),
                       GetSQLValueString($values['comission'], "text"),
                       GetSQLValueString($values['discountpercent'], "text"),
                       GetSQLValueString($values['discount'], "text"),
                       GetSQLValueString($values['markuppercent'], "text"),
                       GetSQLValueString($values['markup'], "text"),
                       GetSQLValueString($values['price'], "text"),
                       GetSQLValueString($values['expdateadvamount'], "text"),
                       GetSQLValueString($values['expdateamount'], "text"),
                       GetSQLValueString($values['quoteuniq'], "text"));


  mysql_select_db($database_sistema, $sistema);

////////////// END INSERT DATABASE CAR


  if ($Result1 = mysql_query($insertSQL, $sistema)) {

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/all_xajax.php?id='.$_GET['id']);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign('all_xajax', 'innerHTML', $name);
$response->Assign('all_xajax', 'style.visibility', 'visible');
$response->Assign('divcarcot', 'innerHTML', '');
$response->Assign('divcarcot', 'style.visibility', 'hidden');
$response->includeScript("quotations_htl.js");

  } else {
     $response->Alert("No se pudieron guardar los datos\nConsulte con su adminmistrador");
     $response->Alert($insertSQL);
  }
	
  return $response;
}


















////////////////////// START GENERAL SEARCH //////////////////////


function generalSearch($dSearch, $inputid, $divshow, $table, $field, $and) {

if ($dSearch == '%') { $dSearchLen = 0; } else { $dSearchLen = 2; }
//if (strlen($dSearch > 1) && strpos($dSearch, '*') == 0) { $dSearchLen = 0; $dSearch = str_replace($dSearch, '*', '%'); } else { $dSearchLen = 3; }

if (strlen($dSearch) >= $dSearchLen) {

require_once('../Connections/sistema.php');

mysql_select_db($database_sistema, $sistema);
$query_sCity = "SELECT ".$field." FROM ".$table." WHERE ".$field." LIKE '".$dSearch."%'".$and;
//$query_sCity = "SELECT name FROM accounts";
$sCity = mysql_query($query_sCity, $sistema) or die(mysql_error());
$row_sCity = mysql_fetch_assoc($sCity);
$totalRows_sCity = mysql_num_rows($sCity);

	if ($table == 'accounts') {	if ($totalRows_sCity == 1) { $result .= $row_sCity['name']; } else { do {  
		$result .= "<span style=\"cursor:hand;\" onmouseover=\"this.style.color='red'\" onmouseout=\"this.style.color=''\" onclick=\"javascript:document.getElementById('".$inputid."').value='".$row_sCity['name']."';\">".$row_sCity['name']."</span><br>"; 
        } while ($row_sCity = mysql_fetch_assoc($sCity)); mysql_free_result($sCity); 
	} }

	if ($table == 'contacts') {	if ($totalRows_sCity == 1) { $result .= $row_sCity['first_name']; } else { do {  
		$result .= "<span style=\"cursor:hand;\" onmouseover=\"this.style.color='red'\" onmouseout=\"this.style.color=''\" onclick=\"javascript:document.getElementById('".$inputid."').value='".$row_sCity['first_name']."';\">".$row_sCity['first_name']."</span><br>"; 
        } while ($row_sCity = mysql_fetch_assoc($sCity)); mysql_free_result($sCity); 
	} }

	if ($table == 'carrental') {	if ($totalRows_sCity == 1) { $result .= $row_sCity['car']; } else { do {  
		$result .= "<span style=\"cursor:hand;\" onmouseover=\"this.style.color='red'\" onmouseout=\"this.style.color=''\" onclick=\"javascript:document.getElementById('".$inputid."').value='".$row_sCity['car']."';\">".$row_sCity['car']."</span><br>"; 
        } while ($row_sCity = mysql_fetch_assoc($sCity)); mysql_free_result($sCity); 
	} }



$response = new xajaxResponse();
//$response->Alert($query_sCity);
if ($totalRows_sCity == 1) {
$response->Assign($inputid, 'value', $result);
$response->Assign($divshow, 'style.visibility', 'hidden');
} else if ($totalRows_sCity == 0) {
$response->Assign($divshow, 'innerHTML', 'No se produjeron resultados');
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign($divshow, 'style.height', '30px');
} else if ($totalRows_sCity > 5) {
$response->Assign($divshow, 'innerHTML', $result);
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign($divshow, 'style.height', '100px');
} else if ($totalRows_sCity < 3) {
$response->Assign($divshow, 'innerHTML', $result);
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign($divshow, 'style.height', '45px');
} else if ($totalRows_sCity < 4) {
$response->Assign($divshow, 'innerHTML', $result);
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign($divshow, 'style.height', '60px');
} else if ($totalRows_sCity >= 4) {
$response->Assign($divshow, 'innerHTML', $result);
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign($divshow, 'style.height', '90px');
} else {
$response->Assign($divshow, 'innerHTML', $result);
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign($divshow, 'style.height', '10px');
}
} else {
$response = new xajaxResponse();
$response->Assign($divshow, 'innerHTML', '');
$response->Assign($divshow, 'style.visibility', 'hidden');
}

return $response;
}

////////////////////// END GENERAL SEARCH //////////////////////























////////////////////// CITY SEARCH START //////////////////////


function citySearch($dSearch, $inputid, $divshow) {

if ($dSearch == '%') { $dSearchLen = 0; } else { $dSearchLen = 3; }

if (strlen($dSearch) >= $dSearchLen) {


require_once('../Connections/sistema.php');

mysql_select_db($database_sistema, $sistema);
$query_sCity = "SELECT count(*), city, country as country FROM cityairport WHERE city LIKE '".$dSearch."%' GROUP BY country, province";
$sCity = mysql_query($query_sCity, $sistema) or die(mysql_error());
$row_sCity = mysql_fetch_assoc($sCity);
$totalRows_sCity = mysql_num_rows($sCity);

	if ($totalRows_sCity == 1) {

        $result .= $row_sCity['city'].', '.$row_sCity['country']; 
        //$response->javascript("1");

	} else {

       do {  

			($row_sCity['cityairport']) ? $ca =  $row_sCity['cityairport']."(".$row_sCity['airportcode'].")" : $ca = '';
			($row_sCity['airportcode']) ? $ac =  $row_sCity['airportcode']."(".$row_sCity['airportcode'].")" : $ac = '';

//        $result .= $row_sCity['city'].', '.$row_sCity['country'].$totalRows_sCity."<br>"; 
        $result .= "<span style=\"cursor:hand;\" onmouseover=\"this.style.color='red'\" onmouseout=\"this.style.color=''\" onclick=\"javascript:document.getElementById('".$inputid."').value='".$row_sCity['city'].', '.$row_sCity['country']."';\">".$row_sCity['city'].', '.$row_sCity['country']."</span><br>"; 

        } while ($row_sCity = mysql_fetch_assoc($sCity)); 
        mysql_free_result($sCity); 
     
	}

$response = new xajaxResponse();

if ($totalRows_sCity == 1) {
$response->Assign($inputid, 'value', $result);
$response->Assign($divshow, 'style.visibility', 'hidden');
} else if ($totalRows_sCity == 0) {
$response->Assign($divshow, 'innerHTML', 'No se produjeron resultados');
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign($divshow, 'style.height', '30px');
} else if ($totalRows_sCity > 5) {
$response->Assign($divshow, 'innerHTML', $result);
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign($divshow, 'style.height', '100px');
} else if ($totalRows_sCity < 3) {
$response->Assign($divshow, 'innerHTML', $result);
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign($divshow, 'style.height', '45px');
} else if ($totalRows_sCity < 4) {
$response->Assign($divshow, 'innerHTML', $result);
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign($divshow, 'style.height', '60px');
} else if ($totalRows_sCity >= 4) {
$response->Assign($divshow, 'innerHTML', $result);
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign('divsearching', 'style.height', '90px');
} else {
$response->Assign($divshow, 'innerHTML', $result);
$response->Assign($divshow, 'style.visibility', 'visible');
$response->Assign($divshow, 'style.height', '10px');
}
} else {
$response = new xajaxResponse();
$response->Assign($divshow, 'innerHTML', '');
$response->Assign($divshow, 'style.visibility', 'hidden');
}
return $response;
}


function citySearchA($dSearch, $inputid) {

if ($dSearch == '%') { $dSearchLen = 0; } else { $dSearchLen = 3; }

if (strlen($dSearch) >= $dSearchLen) {


require_once('../Connections/sistema.php');

mysql_select_db($database_sistema, $sistema);
$query_sCity = "SELECT count(*), city, country as country FROM cityairport WHERE city LIKE '".$dSearch."%' GROUP BY country, province";
$sCity = mysql_query($query_sCity, $sistema) or die(mysql_error());
$row_sCity = mysql_fetch_assoc($sCity);
$totalRows_sCity = mysql_num_rows($sCity);

	if ($totalRows_sCity == 1) {

        $result .= $row_sCity['city'].', '.$row_sCity['country']; 
        //$response->javascript("1");

	} else {

       do {  

			($row_sCity['cityairport']) ? $ca =  $row_sCity['cityairport']."(".$row_sCity['airportcode'].")" : $ca = '';
			($row_sCity['airportcode']) ? $ac =  $row_sCity['airportcode']."(".$row_sCity['airportcode'].")" : $ac = '';

//        $result .= $row_sCity['city'].', '.$row_sCity['country'].$totalRows_sCity."<br>"; 
        $result .= "<span style=\"cursor:hand;\" onmouseover=\"this.style.color='red'\" onmouseout=\"this.style.color=''\" onclick=\"javascript:document.getElementById('".$inputid."').value='".$row_sCity['city'].', '.$row_sCity['country']."';\">".$row_sCity['city'].', '.$row_sCity['country']."</span><br>"; 

        } while ($row_sCity = mysql_fetch_assoc($sCity)); 
        mysql_free_result($sCity); 
     
	}

$response = new xajaxResponse();

if ($totalRows_sCity == 1) {
$response->Assign($inputid, 'value', $result);
$response->Assign('divsearchingA', 'style.visibility', 'hidden');
} else if ($totalRows_sCity == 0) {
$response->Assign('divsearchingA', 'innerHTML', 'No se produjeron resultados');
$response->Assign('divsearchingA', 'style.visibility', 'visible');
$response->Assign('divsearchingA', 'style.height', '30px');
} else if ($totalRows_sCity > 5) {
$response->Assign('divsearchingA', 'innerHTML', $result);
$response->Assign('divsearchingA', 'style.visibility', 'visible');
$response->Assign('divsearchingA', 'style.height', '100px');
} else if ($totalRows_sCity < 3) {
$response->Assign('divsearchingA', 'innerHTML', $result);
$response->Assign('divsearchingA', 'style.visibility', 'visible');
$response->Assign('divsearchingA', 'style.height', '45px');
} else if ($totalRows_sCity < 4) {
$response->Assign('divsearchingA', 'innerHTML', $result);
$response->Assign('divsearchingA', 'style.visibility', 'visible');
$response->Assign('divsearchingA', 'style.height', '60px');
} else if ($totalRows_sCity >= 4) {
$response->Assign('divsearchingA', 'innerHTML', $result);
$response->Assign('divsearchingA', 'style.visibility', 'visible');
$response->Assign('divsearchingA', 'style.height', '90px');
} else {
$response->Assign('divsearchingA', 'innerHTML', $result);
$response->Assign('divsearchingA', 'style.visibility', 'visible');
$response->Assign('divsearchingA', 'style.height', '10px');
}
} else {
$response = new xajaxResponse();
$response->Assign('divsearchingA', 'innerHTML', '');
$response->Assign('divsearchingA', 'style.visibility', 'hidden');
}
return $response;
}




/////////////////// END CITY SEARCH ///////////////////////















/////////////// START CITY SEARCH CLEANER //////////////////////



function citySearchClear() {

$response = new xajaxResponse();
$response->Assign('divsearching', 'innerHTML', '');
$response->Assign('divsearchingA', 'innerHTML', '');
$response->Assign('divoperator', 'innerHTML', '');
$response->Assign('divcontact', 'innerHTML', '');
$response->Assign('divcarcompany', 'innerHTML', '');
$response->Assign('divsearchingpickup', 'innerHTML', '');
$response->Assign('divsearchingdropoff', 'innerHTML', '');

$response->Assign('divsearching', 'style.visibility', 'hidden');
$response->Assign('divsearchingA', 'style.visibility', 'hidden');
$response->Assign('divoperator', 'style.visibility', 'hidden');
$response->Assign('divcontact', 'style.visibility', 'hidden');
$response->Assign('divcarcompany', 'style.visibility', 'hidden');
$response->Assign('divsearchingpickup', 'style.visibility', 'hidden');
$response->Assign('divsearchingdropoff', 'style.visibility', 'hidden');

return $response;
}



function show($kindof, $divshow, $quoteuniq) {

$findvalues = split(",", $quoteuniq);
$quoteuniq = $findvalues[0];
$quoteflyuniq = $findvalues[1];
$hotelquoteid = $findvalues[2];
$hotelquotepriceid = $findvalues[3];
$hotelquotationid = $findvalues[4];

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.dnsba.com/arg/quote_'.$kindof.'_xajax.php?id='.$_GET['id'].'&uid='.$_SESSION['MM_Userid'].'&quoteuniq='.$quoteuniq.'&quoteflyuniq='.$quoteflyuniq.'&hotelquoteid='.$hotelquoteid.'&hotelquotepriceid='.$hotelquotepriceid.'&hotelquotationid='.$hotelquotationid);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$name = curl_exec($ch);
curl_close($ch);
$response = new xajaxResponse();
$response->Assign($divshow, 'innerHTML', $name);
$response->Assign($divshow, 'style.visibility', 'visible');
$response->includeScript("quotations_htl.js");
//$response->Alert($quoteuniq);
return $response;
}


function clear($divhide) {
$response = new xajaxResponse();
$response->Assign($divhide, 'innerHTML', '');
$response->Assign($divhide, 'style.visibility', 'hidden');
//$response->IncludeScript("quotations_htl.js");
return $response;
}


$xajax = new xajax();
$xajax->registerFunction('clear');
$xajax->registerFunction('show');
$xajax->registerFunction('citySearch');
$xajax->registerFunction('citySearchA');
$xajax->registerFunction('generalSearch');
$xajax->registerFunction('addhtl');
$xajax->registerFunction('updatehtlquotation');
$xajax->registerFunction('addhtlquote');
$xajax->registerFunction('updatehtlquote');
$xajax->registerFunction('addhtlquoteprice');
$xajax->registerFunction('updatehtlquoteprice');
$xajax->registerFunction('addfly');
$xajax->registerFunction('addflyow');
$xajax->registerFunction('addflyobo');
$xajax->registerFunction('addflymanual');
$xajax->registerFunction('addflyfrompnr');
$xajax->registerFunction('addcar');
$xajax->registerFunction('addcarquote');
$xajax->registerFunction('rm');
$xajax->registerFunction('citySearchClear');
$xajax->setCharEncoding("ISO-8859-1");
$xajax->processRequest();
?>
<?php $xajax->printJavascript('xajax/');  ?>
<?php require_once('../Connections/sistema.php'); ?>
<?php
$colname_opportunity_view = "1";
if (isset($_GET['id'])) {
  $colname_opportunity_view = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_sistema, $sistema);
$query_opportunity_view = sprintf("SELECT * FROM opportunities WHERE id = %s", $colname_opportunity_view);
$opportunity_view = mysql_query($query_opportunity_view, $sistema) or die(mysql_error());
$row_opportunity_view = mysql_fetch_assoc($opportunity_view);
$totalRows_opportunity_view = mysql_num_rows($opportunity_view);

$colname_hotelquotations = "1";
if (isset($_GET['id'])) {
  $colname_hotelquotations = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_sistema, $sistema);
$query_hotelquotations = sprintf("SELECT * FROM hotelquotation WHERE opportunity_id = %s", $colname_hotelquotations);
$hotelquotations = mysql_query($query_hotelquotations, $sistema) or die(mysql_error());
$row_hotelquotations = mysql_fetch_assoc($hotelquotations);
$totalRows_hotelquotations = mysql_num_rows($hotelquotations);

mysql_select_db($database_sistema, $sistema);
$query_flyquotations = sprintf("SELECT * FROM flyquotation WHERE opportunity_id = %s", $colname_hotelquotations);
$flyquotations = mysql_query($query_flyquotations, $sistema) or die(mysql_error());
$row_flyquotations = mysql_fetch_assoc($flyquotations);
$totalRows_flyquotations = mysql_num_rows($flyquotations);
?>
<?php include("head.php"); 

if ($row_opportunity_view['created_by']) {
$created_by = "por ".find($row_opportunity_view['created_by'],"users","id","user_name"); }

if ($row_opportunity_view['modified_user_id']) {
$modified_user_id = "por ".find($row_opportunity_view['modified_user_id'],"users","id","user_name"); }

?>
<script type="text/javascript">

	function submitform($value)
		{
	if ($value == 'addflyow') { xajax_addflyow(xajax.getFormValues($value)); }
	if ($value == 'addfly') { xajax_addfly(xajax.getFormValues($value)); }
	if ($value == 'addflyobo') { xajax_addflyobo(xajax.getFormValues($value)); }
	if ($value == 'addflymanual') { xajax_addflymanual(xajax.getFormValues($value)); }
	if ($value == 'addflyfrompnr') { xajax_addflyfrompnr(xajax.getFormValues($value)); }
	if ($value == 'addhtl') { xajax_addhtl(xajax.getFormValues($value)); }
	if ($value == 'addcar') { xajax_addcar(xajax.getFormValues($value)); }
	if ($value == 'addcarquote') { xajax_addcarquote(xajax.getFormValues($value)); }
	if ($value == 'addhtlquote') { xajax_addhtlquote(xajax.getFormValues($value)); }
	if ($value == 'addhtlquoteprice') { xajax_addhtlquoteprice(xajax.getFormValues($value)); }
	if ($value == 'updatehtlquoteprice') { xajax_updatehtlquoteprice(xajax.getFormValues($value)); }
	if ($value == 'updatehtlquote') { xajax_updatehtlquote(xajax.getFormValues($value)); }
	if ($value == 'updatehtlquotation') { xajax_updatehtlquotation(xajax.getFormValues($value)); }
		}

</script>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td colspan="3" valign="top"><?php include("top.php"); ?></td>
  </tr>
  <tr>
    <td style="padding-left:9px;" valign="top"><?php include($menu); ?></td>
    <td style="padding-left:9px;padding-right:13px;width:100%;">

<!-- COMIENZA CONTENIDO -->

<br>
<table width='100%' cellpadding='0' cellspacing='0' border='0' class='moduleTitle'>
<tr>
<td valign='top'>
<IMG src='images/Contacts.gif' width='16' height='16' border='0' style='margin-top: 3px;' >&nbsp;</td>
<td width='100%'><h2>Oportunidad: <?php echo $row_opportunity_view['name']; ?></h2></td>
<td valign='top' align='right' nowrap style='padding-top:3px; padding-left: 5px;'>&nbsp;<A href=''  class='utilsLink'>
<img src='images/help.gif' width='13' height='13' alt='Help' border='0' align='middle'></a>&nbsp;<A href=''  class='utilsLink'>Ayuda</A></td>
</tr></table>

<p></p>

<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
	<td style="padding-bottom: 2px;">
<input title="Save [Alt+S]" onClick="location.href='opportunity_edit.php?id=<?php echo $_GET['id']; ?>'" accesskey="S" class="button" type="submit" name="button3" value="  Editar  " >
<input title="Save [Alt+S]" accesskey="S" class="button" type="submit" name="button2" value="  Duplicar  " >
<input title="Cancel [Alt+X]" onClick="return confirmacion('opportunity_del.php?id=<?php echo $_GET['id']; ?>','¿Está seguro que desea eliminar la oportunidad <?php echo $row_opportunity_view['name']; ?>?')" accessKey="X" class="button" type="submit" name="button" value="  Eliminar  ">




</td>
	<td align="right" nowrap>&nbsp;</td>
	<td align='right'></td>
</tr>
</table>
<span class="tabDetailViewDF"></span><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tabDetailView">
<tr>
<td colspan="20" class="listViewPaginationTdS1"  style="font-weight:normal;border-bottom:0px;padding:0px;">

<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td style="text-align: left" class="tabDetailViewDL"><a href="#" class="listViewPaginationLinkS1"  style="font-weight: normal;">Ver archivo de auditoría</a></td>
<td nowrap align="right" class="tabDetailViewDL">
<a href="" class="tabDetailViewDFLink"  style="font-weight: normal;"> Volver a la Lista
</a><img src="images/start_off.gif" width="11" height="9" alt="Start"  border="0" align="absmiddle">
<span  style="font-weight: normal;">Inicio</span><img src="images/previous_off.gif" width="6" height="9" alt="Previous"  border="0" align="absmiddle"><span  style="font-weight: normal;">Anterior</span><span class="tabDetailViewDL"  style="font-weight: normal;">(1 of 3)</span>
<a href="" class="tabDetailViewDFLink"  style="font-weight: normal;">Siguiente</a><a href="" class="tabDetailViewDFLink"  style="font-weight: normal;">
<img src="images/next.gif" width="6" height="9" alt="Next"  border="0" align="absmiddle"></a><a href="" class="tabDetailViewDFLink" style="font-weight: normal;">Fin</a><a href="" class="tabDetailViewDFLink"  style="font-weight: normal;"><img src="images/end.gif" width="11" height="9" alt="End"  border="0" align="absmiddle"></a>
</td>
</tr>
</table>

</td>
</tr>
	<tr>
	<td width="15%" valign="top" class="tabDetailViewDL">Nombre</td>
	<td width="35%" valign="top" class="tabDetailViewDF"><?php echo $row_opportunity_view['name']; ?> </td>
	<td width="15%" valign="top" class="tabDetailViewDL">Monto</td>
	<td width="35%" valign="top" class="tabDetailViewDF"><?php echo ($row_opportunity_view['currency_id']) ? find($row_opportunity_view['currency_id'],"currency","id","currency") : ""; ?> <?php echo $row_opportunity_view['amount']; ?></td>
	</tr><tr>
	<td  valign="top" class="tabDetailViewDL">Contacto</td>
	<td  valign="top" class="tabDetailViewDF"><a target="_blank"></a><?php echo ($row_opportunity_view['customer_id']) ? find($row_opportunity_view['customer_id'],"contacts","id","first_name") : ""; ?> <?php echo ($row_opportunity_view['customer_id']) ? find($row_opportunity_view['customer_id'],"contacts","id","last_name") : ""; ?></td>
	<td  valign="top" class="tabDetailViewDL">Cierre Esperado </td>
	<td  valign="top" class="tabDetailViewDF"><?php echo format_date($row_opportunity_view['date_closed']); ?></td>
	</tr><tr>
	<td  valign="top" class="tabDetailViewDL">Tipo</td>
	<td  valign="top" class="tabDetailViewDF"><a class="tabDetailViewDFLink"> </a><?php echo ($row_opportunity_view['opportunity_type']) ? find($row_opportunity_view['opportunity_type'],"opportunity_type","id","type") : ""; ?></td>
	<td  valign="top" class="tabDetailViewDL">Pr&oacute;ximo paso </td>
	<td  valign="top" class="tabDetailViewDF"><?php echo $row_opportunity_view['next_step']; ?></td>
	</tr><tr>
	<td  valign="top" class="tabDetailViewDL">Origen del Contacto </td>
	<td  valign="top" class="tabDetailViewDF"><?php echo ($row_opportunity_view['lead_source']) ? find($row_opportunity_view['lead_source'],"lead_source","id","lead_source") : ""; ?></td>
	<td  valign="top" class="tabDetailViewDL">Etapa de Ventas </td>
	<td  valign="top" class="tabDetailViewDF"><?php echo ($row_opportunity_view['sales_stage']) ? find($row_opportunity_view['sales_stage'],"sales_stage","id","sales_stage") : ""; ?></td>
	</tr><tr>
	<td  valign="top" class="tabDetailViewDL">&nbsp;</td>
	<td  valign="top" class="tabDetailViewDF"></td>
	<td  valign="top" class="tabDetailViewDL">Probabilidad</td>
	<td  valign="top" class="tabDetailViewDF"><span class="dataField"><?php echo ($row_opportunity_view['probability']) ? find($row_opportunity_view['probability'],"probability","id","probability")."%" : ""; ?></span></td>
	</tr><tr>
	<td  valign="top" class="tabDetailViewDL">Asignado a </td>
	<td  valign="top" class="tabDetailViewDF"><span class="dataField"><?php echo ($row_opportunity_view['assigned_user_id']) ? find($row_opportunity_view['assigned_user_id'],"users","id","user_name") : ""; ?></span></td>
	<td  valign="top" class="tabDetailViewDL">Creado</td>
	<td  valign="top" class="tabDetailViewDF">
		<a href="" class="tabDetailViewDFLink"></a><?php echo format_date($row_opportunity_view['date_entered']); echo "  ".get_time($row_opportunity_view['date_entered'])." ".$created_by; ; ?></td>
	</tr><tr>
	<td  valign="top" class="tabDetailViewDL">Descripci&oacute;n</td>
	<td  valign="top" class="tabDetailViewDF"><span class="dataField"><?php echo $row_opportunity_view['description']; ?>
    </span></td>
	<td  valign="top" class="tabDetailViewDL">Modificado</td>
	<td  valign="top" class="tabDetailViewDF">
		<a href="" class="tabDetailViewDFLink"></a><?php echo format_date($row_opportunity_view['date_modified']); echo "  ".get_time($row_opportunity_view['date_modified'])." ".$modified_user_id; ; ?></td>
	</tr>
</table>

<p></p>

<table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td nowrap><h3>Cotizaciones</h3></td><td width='20'><IMG height='1' width='20' src='include/images/blank.gif' alt=''></td>
<td valign='middle' nowrap width='100%'><div align='right'><span id="show_link_leads" style="display: none"><a href='#' class='utilsLink' onclick="current_child_field = 'leads';showSubPanel('leads');document.getElementById('show_link_leads').style.display='none';document.getElementById('hide_link_leads').style.display='';return false;">Show&nbsp;<img src='themes/SugarLite/images/advanced_search.gif' width='8' height='8' alt="Show" border="0"></a></span><span id="hide_link_leads" style="display: inline"><a href='#' class='utilsLink' onclick="hideSubPanel('leads');document.getElementById('hide_link_leads').style.display='none';document.getElementById('show_link_leads').style.display='';return false;">Hide&nbsp;<img src='themes/SugarLite/images/basic_search.gif' width='8' height='8' alt="Hide" border="0"></a></span></div></td>
</tr>
</table>

<p></p>

<table cellpadding="0" cellspacing="0">
<tr>
<td style="padding-right: 2px; padding-bottom: 2px;">
<form action="index.php" method="post" name="form" id="formformLeads">
  <input title='Create [Alt+H]' accesskey='H' class='button' type='button' name='button1' onClick="javascript:xajax_show('htl', 'divadd', '');" value='  Hotel  '/>  
  <input title='Create [Alt+V]' accesskey='V' class='button' type='button' name='button2' onClick="javascript:xajax_show('fly', 'divadd', '');" value='  Fly RT  '/>
  <input title='Create [Alt+V]' accesskey='V' class='button' type='button' name='button2' onClick="javascript:xajax_show('fly_ow', 'divadd', '');" value='  Fly OW  '/>
  <input title='Create [Alt+V]' accesskey='V' class='button' type='button' name='button3' onClick="javascript:xajax_show('car', 'divadd', '');" value='  Car  '/>
  <input title='Create [Alt+V]' accesskey='V' class='button' type='button' name='button3' onClick="javascript:xajax_show('exc', 'divadd', '');" value='  Excursiones  '/>
</form></td>
<td style="padding-right: 2px; padding-bottom: 2px;">
</td></tr></table>
<div id="divadd" onClick="xajax_citySearchClear('divsearching');" style="z-index:2;position: absolute; top: 50%; left: 50%; margin-top: -100px; margin-left: -250px;">   </div>
<div id="divcarcot" onClick="javascript: xajax_citySearchClear();" style="z-index:2;position: absolute; top: 50%; left: 50%; margin-top: -350px; margin-left: -250px;"></div>

<?php include("all_xajax.php"); ?>



<!-- TERMINA CONTENIDO -->
    </td>
  </tr></table>
<p></p>
<div align="center">
<?php include("footer.php"); ?>

</div>
<?php
mysql_free_result($opportunity_view);

mysql_free_result($hotelquotations);
mysql_free_result($flyquotations);
?>


</body>
</html>
<script language="javascript">
function farecalc(value) {

var p = parseFloat(document.getElementById("price").value);
var tp = parseFloat(document.getElementById("taxpercent").value);
var t = parseFloat(document.getElementById("tax").value);
var cp = parseFloat(document.getElementById("comissionpercent").value);
var c = parseFloat(document.getElementById("comission").value);
var dp = parseFloat(document.getElementById("discountpercent").value);
var d = parseFloat(document.getElementById("discount").value);
var mp = parseFloat(document.getElementById("markuppercent").value);
var m = parseFloat(document.getElementById("markup").value);

if (value == 'tax') { document.getElementById("taxpercent").value = ((t/p)*100).toFixed(1); }
if (value == 'taxpercent') { document.getElementById("tax").value = ((p/100)*tp).toFixed(2); }
if (value == 'comission') { document.getElementById("comissionpercent").value = ((c/p)*100).toFixed(1); }
if (value == 'comissionpercent') { document.getElementById("comission").value = ((p/100)*cp).toFixed(2); }
if (value == 'discount') { document.getElementById("discountpercent").value = ((d/p)*100).toFixed(1); }
if (value == 'discountpercent') { document.getElementById("discount").value = ((p/100)*dp).toFixed(2); }
if (value == 'markup') { document.getElementById("markuppercent").value = ((m/p)*100).toFixed(1); }
if (value == 'markuppercent') { document.getElementById("markup").value = ((p/100)*mp).toFixed(2); }

if (value == 'price') { 
document.getElementById("tax").value = ((p/100)*tp).toFixed(2);
document.getElementById("comission").value = ((p/100)*cp).toFixed(2);
document.getElementById("discount").value = ((p/100)*dp).toFixed(2);
document.getElementById("markup").value = ((p/100)*mp).toFixed(2); 
}

var p = parseFloat(document.getElementById("price").value);
var tp = parseFloat(document.getElementById("taxpercent").value);
var t = parseFloat(document.getElementById("tax").value);
var cp = parseFloat(document.getElementById("comissionpercent").value);
var c = parseFloat(document.getElementById("comission").value);
var dp = parseFloat(document.getElementById("discountpercent").value);
var d = parseFloat(document.getElementById("discount").value);
var mp = parseFloat(document.getElementById("markuppercent").value);
var m = parseFloat(document.getElementById("markup").value);


sp = (p+t+m-d);
document.getElementById("salesprice").innerText = parseFloat(sp).toFixed(2);


}

function stripBad(string) {
    for (var i=0, output='', valid="eE+/*-0123456789.()"; i<string.length; i++)
       if (valid.indexOf(string.charAt(i)) != -1)
          output += string.charAt(i)
    return output;
} 

</script>