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')); }