function sendContact()
{
$property = requestBody();
$send_eual_cam_name = $property->send_eual_cam_name;
$send_eual_cam_email = $property->send_eual_cam_email;
$send_eual_cam_message = $property->send_eual_cam_message;
send_contacto($send_eual_cam_name, $send_eual_cam_email, $send_eual_cam_message);
echo changeArrayIntoJSON("contacto", array('process' => 'ok'));
}
function api_data_form_contact_by_promo()
{
$property = requestBody();
$send_man_cam_contact_by_promo_firstname = $property->man_cam_contact_by_promo_firstname;
$send_man_cam_contact_by_promo_lastname = $property->man_cam_contact_by_promo_lastname;
$send_man_cam_contact_by_promo_email = $property->man_cam_contact_by_promo_email;
$send_man_cam_contact_by_promo_phone = $property->man_cam_contact_by_promo_phone;
$send_man_cam_contact_by_promo_message = $property->man_cam_contact_by_promo_message;
$send_man_cam_contact_by_promo_title_name = $property->man_cam_contact_by_promo_title_name;
$url = 'http://euroalemanacamiones.com.mx/';
send_contact_by_promo($url, $send_man_cam_contact_by_promo_firstname, $send_man_cam_contact_by_promo_lastname, $send_man_cam_contact_by_promo_email, $send_man_cam_contact_by_promo_phone, $send_man_cam_contact_by_promo_message, $send_man_cam_contact_by_promo_title_name);
echo changeArrayIntoJSON("contact", array('process' => 'ok'));
}
function changeQueryIntoJSON($nameJSON, $structure, $connection, $sql, $params, $operation, $pdo)
{
$result = restructureQuery($structure, $connection, $sql, $params, $operation, $pdo);
return changeArrayIntoJSON($nameJSON, $result);
}
function sendFinancingByModelCiaz()
{
$property = requestBody();
$send_suk_gdl_financing_by_model_car_engagement = $property->suk_gdl_financing_by_model_car_engagement;
$send_suk_gdl_financing_by_model_car_monthly_payment = $property->suk_gdl_financing_by_model_car_monthly_payment;
$send_suk_gdl_financing_by_model_car_months = $property->suk_gdl_financing_by_model_car_months;
$send_suk_gdl_financing_by_model_car_price = $property->suk_gdl_financing_by_model_car_price;
$send_suk_gdl_financing_by_model_concesionarie = $property->suk_gdl_financing_by_model_concesionarie;
$send_suk_gdl_financing_by_model_drive = $property->suk_gdl_financing_by_model_drive;
$send_suk_gdl_financing_by_model_email = $property->suk_gdl_financing_by_model_email;
$send_suk_gdl_financing_by_model_image_model = $property->suk_gdl_financing_by_model_image_model;
$send_suk_gdl_financing_by_model_lastname = $property->suk_gdl_financing_by_model_lastname;
$send_suk_gdl_financing_by_model_model_car = $property->suk_gdl_financing_by_model_model_car;
$send_suk_gdl_financing_by_model_model_key = $property->suk_gdl_financing_by_model_model_key;
$send_suk_gdl_financing_by_model_name = $property->suk_gdl_financing_by_model_name;
$send_suk_gdl_financing_by_model_newsletter = $property->suk_gdl_financing_by_model_newsletter;
$send_suk_gdl_financing_by_model_subscription = $property->suk_gdl_financing_by_model_subscription;
$send_suk_gdl_financing_by_model_tel = $property->suk_gdl_financing_by_model_tel;
$send_suk_gdl_financing_by_model_model_car_verison = $property->suk_gdl_financing_by_model_model_car_verison;
$send_suk_gdl_financing_by_model_url = "suzukimorelia";
if (isset($send_suk_gdl_financing_by_model_newsletter) && $send_suk_gdl_financing_by_model_newsletter === "on") {
$send_suk_gdl_financing_by_model_subscription = "Activado";
send_news_financing_by_model($send_suk_gdl_financing_by_model_url, $send_suk_gdl_financing_by_model_name, $send_suk_gdl_financing_by_model_lastname, $send_suk_gdl_financing_by_model_email, $send_suk_gdl_financing_by_model_newsletter, $send_suk_gdl_financing_by_model_concesionarie, $send_suk_gdl_financing_by_model_subscription);
} else {
$send_suk_gdl_financing_by_model_subscription = "Desactivado";
}
send_financing_by_model($send_suk_gdl_financing_by_model_drive, $send_suk_gdl_financing_by_model_model_car_verison, $send_suk_gdl_financing_by_model_url, $send_suk_gdl_financing_by_model_car_engagement, $send_suk_gdl_financing_by_model_car_monthly_payment, $send_suk_gdl_financing_by_model_car_months, $send_suk_gdl_financing_by_model_car_price, $send_suk_gdl_financing_by_model_name, $send_suk_gdl_financing_by_model_lastname, $send_suk_gdl_financing_by_model_email, $send_suk_gdl_financing_by_model_tel, $send_suk_gdl_financing_by_model_model_car, $send_suk_gdl_financing_by_model_newsletter, $send_suk_gdl_financing_by_model_concesionarie, $send_suk_gdl_financing_by_model_model_car, $send_suk_gdl_financing_by_model_image_model, $send_suk_gdl_financing_by_model_subscription);
send_financing_by_model_confirm($send_suk_gdl_financing_by_model_drive, $send_suk_gdl_financing_by_model_model_car_verison, $send_suk_gdl_financing_by_model_url, $send_suk_gdl_financing_by_model_car_engagement, $send_suk_gdl_financing_by_model_car_monthly_payment, $send_suk_gdl_financing_by_model_car_months, $send_suk_gdl_financing_by_model_car_price, $send_suk_gdl_financing_by_model_name, $send_suk_gdl_financing_by_model_lastname, $send_suk_gdl_financing_by_model_email, $send_suk_gdl_financing_by_model_tel, $send_suk_gdl_financing_by_model_model_car, $send_suk_gdl_financing_by_model_newsletter, $send_suk_gdl_financing_by_model_concesionarie, $send_suk_gdl_financing_by_model_model_car, $send_suk_gdl_financing_by_model_image_model, $send_suk_gdl_financing_by_model_subscription);
echo changeArrayIntoJSON("sukpa", array('process' => 'ok', $property));
}
function changeQueryIntoJSON($nameJSON, $structure, $connection, $sql, $params, $operation, $pdo)
{
$result = generalQuery($connection, $sql, $params, $operation, $pdo);
$restructured = $operation === 0 && rightResult($result) ? restructureArray($result, $structure) : $result;
return changeArrayIntoJSON($nameJSON, $restructured);
}
function sendContactoSEMSUKLMByModel()
{
$property = requestBody();
$sem_suklm_contact_bm_name = ucwords($property->sem_suklm_contact_by_model_name);
$sem_suklm_contact_bm_email = $property->sem_suklm_contact_by_model_email;
$sem_suklm_contact_bm_phone = $property->sem_suklm_contact_by_model_phone;
$sem_suklm_contact_bm_message = $property->sem_suklm_contact_by_model_message;
$sem_suklm_contact_bm_send_email = $property->sem_suklm_contact_by_model_send_email;
$sem_suklm_contact_bm_concessionary = $property->sem_suklm_contact_by_model_concessionary;
$sem_suklm_contact_bm_logo_seminuevos = $property->sem_suklm_contact_by_model_logo_seminuevos;
$sem_suklm_contact_bm_marc = $property->sem_suklm_contact_by_model_marc;
$sem_suklm_contact_bm_model = $property->sem_suklm_contact_by_model_model;
$sem_suklm_contact_bm_picture = $property->sem_suklm_contact_by_model_picture;
sem_suklm_bymodel_contacto($sem_suklm_contact_bm_name, $sem_suklm_contact_bm_email, $sem_suklm_contact_bm_phone, $sem_suklm_contact_bm_message, $sem_suklm_contact_bm_send_email, $sem_suklm_contact_bm_concessionary, $sem_suklm_contact_bm_logo_seminuevos, $sem_suklm_contact_bm_marc, $sem_suklm_contact_bm_model, $sem_suklm_contact_bm_picture);
echo changeArrayIntoJSON("semlm", array('process' => 'ok'));
}
function getTest()
{
$today = date('o-m-d H:i:s');
$array = array('date' => $today);
echo changeArrayIntoJSON('propa', $array);
}
function getRental()
{
$sql_agencias = "SELECT *\r\n FROM (\r\n SELECT *\r\n FROM camAgencias\r\n WHERE AGN_Tipo = 3\r\n ) agn\r\n ";
$sql_telefonos = "SELECT *\r\n FROM camTelefonos\r\n WHERE TEL_AGN_Id = :telefonos\r\n ";
$params_agencias = array();
$structure_agencias = array('agnId' => 'AGN_Id', 'agpid' => 'AGN_AGP_Id', 'agnTipo' => 'AGN_Tipo', 'agnNombre' => 'AGN_Nombre', 'agnDireccion' => 'AGN_Dirección', 'agnSmall' => 'AGN_Small');
$structure_telefonos = array('telId' => 'TEL_AGN_Id', 'telefono' => 'TEL_Telefono', 'call' => 'TEL_Call');
$result_agencias = restructureQuery($structure_agencias, getConnection(), $sql_agencias, $params_agencias, 0, PDO::FETCH_ASSOC);
for ($idx = 0; $idx < count($result_agencias); $idx++) {
$agnId = $result_agencias[$idx]['agnId'];
$result_agencias[$idx]['columns'] = $idx % 2 === 0 ? 'col-md-offset-7 col-sm-offset-5' : '';
$result_agencias[$idx]['textAlign'] = $idx % 2 === 0 ? 'text-left' : 'text-right';
$result_agencias[$idx]['direction'] = $idx % 2 === 0 ? 'pull-left' : 'pull-right';
// TELEFONOS
$params_telefonos = array('telefonos' => $agnId);
$result_telefonos = generalQuery(getConnection(), $sql_telefonos, $params_telefonos, 0, PDO::FETCH_ASSOC);
$result_telefonos = count($result_telefonos) > 0 ? restructureRow($result_telefonos[0], $structure_telefonos) : array();
$result_agencias[$idx]['telefonos'] = $result_telefonos;
}
$json = changeArrayIntoJSON('campa', $result_agencias);
echo $json;
}
function sendConfirmAssistance()
{
$property = requestBody();
$send_suk_event_full_name = $property->suk_event_full_name;
$send_suk_event_phone = $property->suk_event_phone;
$send_suk_event_email = $property->suk_event_email;
$send_suk_event_concessionaire = 'suzukigdl';
send_confirm_assistance_confirm($send_suk_event_full_name, $send_suk_event_phone, $send_suk_event_email, $send_suk_event_concessionaire);
send_confirm_assistance($send_suk_event_full_name, $send_suk_event_phone, $send_suk_event_email, $send_suk_event_concessionaire);
echo changeArrayIntoJSON("suklpa", array('process' => 'ok'));
}
function getCatalogoJSON($sql, $marId)
{
$structure = array('id' => 'SEN_Id', 'id_marc' => 'MAR_Id', 'agencia' => 'AGN_Nombre', 'logo' => 'AGN_Logo', 'marca' => 'MAR_Nombre', 'categoria' => 'CAT_Nombre', 'modelo' => 'MDO_Nombre', 'mrc_nombre' => 'MAR_NombreShort', 'mdo_nombre' => 'MDO_NombreShort', 'year' => 'SEN_Year', 'precio' => 'SEN_Precio', 'cilindros' => 'SEN_Cilindros', 'transmision' => 'SEN_Transmision', 'color' => 'SEN_Color', 'interior' => 'SEN_Interior', 'agencia' => 'AGN_Nombre', 'folder' => 'AGN_Folder', 'thumb' => 'THM_Nombre', 'telefonos' => array('agnTelefono' => 'TEL_Telefono'), 'llamanos' => array('agnCall' => 'TEL_Call'));
$params = array();
$marId !== '' ? $params['marId'] = $marId : ($params = $params);
$result = restructureQuery($structure, getConnection(), $sql, $params, 0, PDO::FETCH_ASSOC);
for ($idx = 0; $idx < count($result); $idx++) {
$result[$idx]['si_thumb'] = $result[$idx]['thumb'] == 'thm_default_camcar.jpg' ? '' : '1';
}
echo changeArrayIntoJSON('campa', $result);
}
function getTransmision()
{
$sql = "SELECT *, COUNT(*) AS SEN_Number\r\n FROM camSeminuevos sen\r\n GROUP BY SEN_Transmision\r\n ORDER BY SEN_Id ASC\r\n ";
/*$structure = array(
'id_mdo' => 'MDO_Id',
'nombre_mdo' => 'MDO_Nombre',
'id_marc' => 'MAR_Id',
'nombre_marc' => 'MAR_Nombre',
'cantidad' => 'MAR_Number',
);*/
$structure = array("modelo" => array("transmision" => "SEN_Transmision", "id_sen" => "SEN_Id", "cantidad" => "SEN_Number"));
$params = array();
$orderBy = array();
$result = generalQuery(getConnection(), $sql, $params, 0, PDO::FETCH_ASSOC);
$detail = array();
$detail = multiLevelJSON($result, $structure, $orderBy);
echo changeArrayIntoJSON('campa', $detail);
//echo changeQueryIntoJSON('campa', $structure, getConnection(), $sql, $params, 0, PDO::FETCH_ASSOC);
}
function sendContactoSEMPREMByModel()
{
$property = requestBody();
$sem_con_sp_bm_name = $property->sem_premium_by_model_contact_name;
$sem_con_sp_bm_email = $property->sem_premium_by_model_contact_email;
$sem_con_sp_bm_phone = $property->sem_premium_by_model_contact_phone;
$sem_con_sp_bm_message = $property->sem_premium_by_model_contact_message;
$sem_con_sp_bm_concessionary = $property->sem_premium_by_model_contact_concessionary;
$sem_con_sp_bm_logo_seminuevos = $property->sem_premium_by_model_contact_logo_seminuevos;
$sem_con_sp_bm_logo_agencia = $property->sem_premium_by_model_contact_logo_agencia;
$sem_con_sp_bm_marc = $property->sem_premium_by_model_contact_marc;
$sem_con_sp_bm_model = $property->sem_premium_by_model_contact_model;
$sem_con_sp_bm_picture = $property->sem_premium_by_model_contact_picture;
sem_premium_bymodel_contacto($sem_con_sp_bm_name, $sem_con_sp_bm_email, $sem_con_sp_bm_phone, $sem_con_sp_bm_message, $sem_con_sp_bm_concessionary, $sem_con_sp_bm_logo_seminuevos, $sem_con_sp_bm_logo_agencia, $sem_con_sp_bm_marc, $sem_con_sp_bm_model, $sem_con_sp_bm_picture);
echo changeArrayIntoJSON("campa", array('process' => 'ok'));
}
function sendContact()
{
$property = requestBody();
$send_par_contact_full_name = $property->par_contact_full_name;
$send_par_contact_email = $property->par_contact_email;
$send_par_contact_full_address = $property->par_contact_full_address;
//$send_par_contact_concessionaire = 'parking.medigraf.com.mx';
$send_par_contact_concessionaire = 'parkingmexico.com/topestacionamiento';
send_contact_confirm($send_par_contact_full_name, $send_par_contact_email, $send_par_contact_full_address, $send_par_contact_concessionaire);
send_contact($send_par_contact_full_name, $send_par_contact_email, $send_par_contact_full_address, $send_par_contact_concessionaire);
echo changeArrayIntoJSON("parpa", array('process' => 'ok'));
}
