rendered paste body<?phprequire('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'].'"euniq='.$quoteuniq.'"eflyuniq='.$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;' > </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;'> <A href='' class='utilsLink'><img src='images/help.gif' width='13' height='13' alt='Help' border='0' align='middle'></a> <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> </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ó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"> </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ó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 <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 <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><?phpmysql_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>