1751 lines
78 KiB
PHP
1751 lines
78 KiB
PHP
<?php
|
|
|
|
/**
|
|
* Main JSON Rest api for LGCCC Conferences
|
|
*/
|
|
|
|
//Enable error reporting for dev only
|
|
error_reporting(E_ERROR | E_PARSE);
|
|
|
|
//Enable compression/output buffering
|
|
if(substr_count($_SERVER['HTTP_ACCEPT_ENCODING'], 'gzip')) ob_start("ob_gzhandler"); else ob_start();
|
|
|
|
//Set required response headers
|
|
header("Access-Control-Allow-Origin: *");
|
|
header('Access-Control-Allow-Credentials: true');
|
|
header('Access-Control-Max-Age: 86400'); // cache for 1 day
|
|
|
|
// Access-Control headers are received during OPTIONS requests
|
|
if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
|
|
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD']))
|
|
header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS");
|
|
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']))
|
|
header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}");
|
|
}
|
|
|
|
//Set JSON response format for header
|
|
header("Content-Type: application/json; charset=UTF-8");
|
|
|
|
//Include required files
|
|
include_once( '../inc/db.php' );
|
|
include_once( '../inc/conferencia.php' );
|
|
include_once( '../inc/helpers.php' );
|
|
include_once( './Converter.php' );
|
|
include_once( './ConverterExtra.php' );
|
|
include_once( './Parser.php' );
|
|
|
|
//Set incoming variables, parse and validate
|
|
if($_REQUEST){
|
|
$func = ($_REQUEST['f']!=''?$_REQUEST['f']:'list');
|
|
$h = ($_REQUEST['h']!=''?$_REQUEST['h']:false);
|
|
$p = ($_REQUEST['p']!=''?$_REQUEST['p']:false);
|
|
$file = ($_REQUEST['file']!=''?$_REQUEST['file']:false);
|
|
$q = $_REQUEST['query'];
|
|
$return = ($_REQUEST['return']!=''?$_REQUEST['return']:true);
|
|
$overwrite = ($_REQUEST['overwrite']!=''?$_REQUEST['overwrite']:false);
|
|
$id = $_REQUEST['id'];
|
|
$co = $_REQUEST['country_code'];
|
|
$last_update = ($_REQUEST['last_update']!=''?$_REQUEST['last_update']:'');
|
|
$text = $_REQUEST['t'];
|
|
$year = ($_REQUEST['year']!=''?$_REQUEST['year']:'');
|
|
$month = ($_REQUEST['month']!=''?$_REQUEST['month']:'');
|
|
$cache = ($_REQUEST['cache']!=''?$_REQUEST['cache']:false);
|
|
$algolia = false;
|
|
$limit = ($_REQUEST['limit']!=''?$_REQUEST['limit']:'');
|
|
$letter = ($_REQUEST['letter']!=''?$_REQUEST['letter']:'a');
|
|
$country = ($_REQUEST['country']!=''?$_REQUEST['country']:'pr');
|
|
define('RELEVANT', ($_REQUEST['relevant']!=''?$_REQUEST['relevant']:false));
|
|
define('EXPORT', ($_REQUEST['export']!=''?$_REQUEST['export']:false));
|
|
if($_REQUEST['locale']!=''){
|
|
if($_REQUEST['locale']=='es'){
|
|
define('LOCALE', 'es_ES');
|
|
} else {
|
|
define('LOCALE', $_REQUEST['locale']);
|
|
}
|
|
} else {
|
|
define('LOCALE', 'es_ES');
|
|
}
|
|
}
|
|
|
|
switch ( $func ){
|
|
case "id_list":
|
|
id_list();
|
|
break;
|
|
case "country_list":
|
|
conferences_country_list($country);
|
|
break;
|
|
case "letter_list":
|
|
conferences_letter_list($letter);
|
|
break;
|
|
case "algolia":
|
|
$algolia = true;
|
|
conferences_list($year,$month,$last_update,false,$cache,true);
|
|
break;
|
|
case "lgccctv":
|
|
conference_list_lgccctv();
|
|
break;
|
|
case "years":
|
|
conference_years();
|
|
break;
|
|
case "download":
|
|
conference_download($h,$p,$file);
|
|
break;
|
|
case "epub":
|
|
conference_epub($id,$return,$overwrite);
|
|
break;
|
|
case "country_conferences":
|
|
country_conferences($co);
|
|
break;
|
|
case "countries":
|
|
countries_list();
|
|
break;
|
|
case "content_search":
|
|
conference_content_search($q);
|
|
break;
|
|
case "search":
|
|
conference_search($q);
|
|
break;
|
|
case "detail":
|
|
conference_detail($id);
|
|
break;
|
|
case "summary":
|
|
conference_detail($id,false);
|
|
break;
|
|
case "last_update":
|
|
conference_last_update( $id );
|
|
break;
|
|
case "texts":
|
|
conferences_list($year,$month,$last_update,true,$cache);
|
|
break;
|
|
case "list":
|
|
default:
|
|
conferences_list($year,$month,$last_update,false,$cache,$limit);
|
|
break;
|
|
}
|
|
|
|
function id_list(){
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
|
|
$stmt = $conference->file_list( LOCALE );
|
|
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
$conferences_arr=array();
|
|
$thumb_urls = [];
|
|
$youtube_urls = [];
|
|
$video_urls = [];
|
|
$audio_urls = [];
|
|
$pdf_simple_urls = [];
|
|
$pdf_booklet_urls = [];
|
|
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
extract($row);
|
|
|
|
$date = '';
|
|
$no_activity = '';
|
|
$city = '';
|
|
$state = '';
|
|
$country = '';
|
|
|
|
$response_item=array(
|
|
//"title" => $title,
|
|
"wpid" => $ID
|
|
);
|
|
|
|
$translations = unserialize($translationmeta);
|
|
$translations[LOCALE] = (int)$ID;
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
$confmeta = $conference->conference_meta( $original_id );
|
|
|
|
extract($confmeta);
|
|
|
|
$code = getFilePrefix() . '-' . date("Y-m-d", strtotime( $date ) ) . '-' . $no_activity;
|
|
|
|
//Title
|
|
$newTitle = sanitize_title( $title );
|
|
$fixedNewTitle = str_replace( '-','_',$newTitle );
|
|
|
|
$newFilename = $code . "-" . $fixedNewTitle . "-" . strtoupper( substr( $city , 0 , 3 ) ) . strtoupper( $country );
|
|
|
|
//$response_item['date'] = $date;
|
|
//$response_item['activity'] = $no_activity;
|
|
$response_item['fileslug'] = getFilePrefix() . '-' . $date . '-' . $no_activity . '_' . $slug;
|
|
if($thumbnail != '' && $thumbnail != null){
|
|
//$response_item['thumbnail'] = 'https://ewr1.vultrobjects.com/lgccc-conferences/' . $thumbnail;
|
|
array_push($thumb_urls,'https://ewr1.vultrobjects.com/lgccc-conferences/' . $thumbnail);
|
|
}
|
|
|
|
$fileData = $conference->get_post_files( $ID, LOCALE );
|
|
$files = $fileData->fetch(PDO::FETCH_ASSOC);
|
|
|
|
if($files['youtube']!=''){
|
|
//$response_item['youtube'] = str_replace( 'http://', 'https://', $files['youtube']);
|
|
array_push($youtube_urls,str_replace( 'http://', 'https://', $files['youtube']));
|
|
}
|
|
|
|
if($files['videofile'] != '' && $files['videofile'] !== null){
|
|
//$response_item['video'] = $conference->get_post_file($files['videofile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
array_push($video_urls,$conference->get_post_file($files['videofile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url']);
|
|
} else if($files['video'] != '' && $files['video'] !== null) {
|
|
//$response_item['video'] = str_replace( 'http://', 'https://',$files['video']);
|
|
array_push($video_urls,str_replace( 'http://', 'https://',$files['video']));
|
|
}
|
|
|
|
if($files['audiofile'] != '' && $files['audiofile'] !== null){
|
|
array_push($audio_urls,$conference->get_post_file($files['audiofile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url']);
|
|
} else if ($files['audio'] != '' && $files['audio'] !== null){
|
|
array_push($audio_urls,str_replace( 'http://', 'https://',$files['audio']));
|
|
}
|
|
|
|
if($files['pdffile'] != '' && $files['pdffile'] !== null){
|
|
array_push($pdf_booklet_urls,$conference->get_post_file($files['pdffile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url']);
|
|
} else if ( $files['pdf'] != '' && $files['pdf'] !== null ){
|
|
array_push($pdf_booklet_urls,str_replace( 'http://', 'https://',$files['pdf']));
|
|
}
|
|
|
|
if($files['pdfsimplefile'] != '' && $files['pdfsimplefile'] !== null){
|
|
array_push($pdf_simple_urls,$conference->get_post_file($files['pdfsimplefile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url']);
|
|
} else if ( $files['pdf_simple'] != '' && $files['pdf_simple'] !== null){
|
|
array_push($pdf_simple_urls,str_replace( 'http://', 'https://',$files['pdf_simple']));
|
|
}
|
|
|
|
//$response_item['translations'] = $translations;
|
|
|
|
//Image metadata for thumbnail use. TODO: Optimize this return array
|
|
//$response_item['meta'] = unserialize($meta);
|
|
/*$dt = new DateTime($date);
|
|
$formatter = new IntlDateFormatter(LOCALE, IntlDateFormatter::SHORT, IntlDateFormatter::SHORT);
|
|
$formatter->setPattern( datePattern( $date ) );
|
|
$response_item['nicedate'] = ucfirst($formatter->format($dt));
|
|
$response_item['location'] = implode(', ',array_filter(array($city,$state,Locale::getDisplayRegion('-'.strtoupper($country), LOCALE ))));*/
|
|
|
|
array_push($conferences_arr, $response_item);
|
|
}
|
|
}
|
|
|
|
//Add activities data as well
|
|
//$activities_json = json_decode(file_get_contents('https://actividadeswp.carpa.com/wp-admin/admin-ajax.php?action=processQueue'), JSON_UNESCAPED_UNICODE | JSON_NUMERIC_CHECK );
|
|
|
|
//$all_data = array_merge($conferences_arr,$activities_json);
|
|
|
|
$temp_arr = array_reverse($conferences_arr);
|
|
|
|
$data = array(
|
|
'count' => count($temp_arr),
|
|
'result' => array (
|
|
'conferencias' => $temp_arr,
|
|
'thumbs' => $thumb_urls,
|
|
'videos' => $video_urls,
|
|
'audios' => $audio_urls,
|
|
'pdfs' => $pdf_simple_urls,
|
|
'pdf_booklets' => $pdf_booklet_urls
|
|
)
|
|
);
|
|
|
|
send_response( $data );
|
|
}
|
|
|
|
function conference_list_lgccctv(){
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
|
|
$stmt = $conference->lgccctv_list( LOCALE );
|
|
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
$conferences_arr=array();
|
|
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
extract($row);
|
|
|
|
$date = '';
|
|
$no_activity = '';
|
|
$city = '';
|
|
$state = '';
|
|
$country = '';
|
|
|
|
$response_item=array(
|
|
"title" => $title
|
|
);
|
|
|
|
$translations = unserialize($translationmeta);
|
|
$translations[LOCALE] = (int)$ID;
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
$confmeta = $conference->conference_meta( $original_id );
|
|
|
|
extract($confmeta);
|
|
|
|
$response_item['date'] = $date;
|
|
$response_item['activity'] = $no_activity;
|
|
|
|
$dt = new DateTime($date);
|
|
$formatter = new IntlDateFormatter(LOCALE, IntlDateFormatter::SHORT, IntlDateFormatter::SHORT);
|
|
$formatter->setPattern( datePattern( $date ) );
|
|
$response_item['nicedate'] = ucfirst($formatter->format($dt));
|
|
$response_item['location'] = implode(', ',array_filter(array($city,$state,Locale::getDisplayRegion('-'.strtoupper($country), LOCALE ))));
|
|
|
|
array_push($conferences_arr, $response_item);
|
|
}
|
|
}
|
|
|
|
//Add activities data as well
|
|
$activities_json = json_decode(file_get_contents('https://actividadeswp.carpa.com/wp-admin/admin-ajax.php?action=processQueue'), JSON_UNESCAPED_UNICODE | JSON_NUMERIC_CHECK );
|
|
|
|
$all_data = array_merge($conferences_arr,$activities_json);
|
|
|
|
$data = array(
|
|
'count' => count($all_data),
|
|
'result' => array (
|
|
'conferencias' => $all_data
|
|
)
|
|
);
|
|
|
|
send_response( $data );
|
|
}
|
|
|
|
/**
|
|
* Create conference list with cache option
|
|
*/
|
|
function conferences_list( $year, $month, $last_update, $text, $cache, $algolia=false ){
|
|
|
|
if( $cache==false ){
|
|
|
|
//Cache directory
|
|
$dir = '/var/www/html/v3/cache';
|
|
//Define filename
|
|
$filen = 'conferencias_' . LOCALE;
|
|
//Set filename for relevant conferences
|
|
if( RELEVANT ){
|
|
$filen .= '_relevant';
|
|
} else {
|
|
//If year
|
|
if($year != ''){
|
|
$filen .= '_' . $year;
|
|
if($month != ''){
|
|
$filen .= '_' . $month;
|
|
}
|
|
}
|
|
}
|
|
if($text){
|
|
$filen .= '_texts';
|
|
}
|
|
$file = $dir . '/' . $filen . '.json';
|
|
if(!file_exists( $file ) || $_REQUEST['forceupdate']==true ){
|
|
$data = build_conferences_list( $year, $month, $last_update, $text, $algolia );
|
|
$data['cache'] = time();
|
|
$data['filename'] = $filen;
|
|
$res = file_put_contents( $file , json_encode($data) );
|
|
$data['res'] = $res;
|
|
} else {
|
|
readfile( $file );
|
|
die();
|
|
}
|
|
|
|
} else {
|
|
|
|
$data = build_conferences_list( $year, $month, $last_update, $text, $algolia );
|
|
$data['cache'] = $cache;
|
|
|
|
}
|
|
|
|
send_response( $data );
|
|
}
|
|
|
|
/**
|
|
* Conferences country list
|
|
*/
|
|
function conferences_country_list( $country, $limit=100 ){
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
|
|
$data = [];
|
|
|
|
$stmt = $conference->country_list( $country, $limit );
|
|
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
$conferences_arr=array();
|
|
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
extract($row);
|
|
|
|
$date = '';
|
|
$no_activity = '';
|
|
$city = '';
|
|
$state = '';
|
|
$country = '';
|
|
$thumbnail = '';
|
|
|
|
$response_item=array(
|
|
"_id" => $ID,
|
|
"title" => $title,
|
|
"slug" => $slug
|
|
);
|
|
|
|
if(!$algolia){
|
|
$response_item["hasText"] = ($bodylength>0?true:false);
|
|
}
|
|
|
|
$translations = unserialize($translationmeta);
|
|
$translations[LOCALE] = (int)$ID;
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
foreach($translations as $translation_locale=>$translation_id){
|
|
$the_slug = $conference->translation_slug( $translation_locale, $translation_id);
|
|
$row = $the_slug->fetch(PDO::FETCH_ASSOC);
|
|
$translations[$translation_locale.'_slug'] = $row['slug'];
|
|
}
|
|
|
|
$confmeta = $conference->conference_meta( $original_id );
|
|
|
|
extract($confmeta);
|
|
|
|
$response_item['date'] = (new DateTime($date, new DateTimeZone('America/Bogota')))->format('Y-m-d');
|
|
$response_item['timestamp'] = (new DateTime($date, new DateTimeZone('America/Bogota')))->getTimestamp();
|
|
$response_item['activity'] = $no_activity;
|
|
$response_item['city'] = $city;
|
|
$response_item['state'] = $state;
|
|
$response_item['country'] = $country;
|
|
if(!$algolia){
|
|
$response_item['private'] = $private;
|
|
}
|
|
$response_item['thumbnail'] = $thumbnail;
|
|
|
|
|
|
$dt = new DateTime($date);
|
|
$formatter = new IntlDateFormatter(LOCALE, IntlDateFormatter::SHORT, IntlDateFormatter::SHORT);
|
|
$formatter->setPattern( datePattern( $date ) );
|
|
$response_item['nicedate'] = ucfirst($formatter->format($dt));
|
|
$response_item['location'] = implode(', ',array_filter(array($city,$state,Locale::getDisplayRegion('-'.strtoupper($country), LOCALE ))));
|
|
$response_item['duration'] = gmdate("H:i:s", (int)$duration);
|
|
|
|
array_push($conferences_arr,$response_item);
|
|
}
|
|
}
|
|
|
|
$data = array(
|
|
'count' => $num,
|
|
'result' => array (
|
|
'conferencias' => $conferences_arr
|
|
)
|
|
);
|
|
|
|
echo json_encode($data);
|
|
die();
|
|
|
|
return $data;
|
|
}
|
|
|
|
/**
|
|
* Conferences letter list
|
|
*/
|
|
function conferences_letter_list( $letter, $limit=100 ){
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
|
|
$data = [];
|
|
|
|
$stmt = $conference->letter_list( $letter, LOCALE );
|
|
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
$conferences_arr=array();
|
|
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
extract($row);
|
|
|
|
$date = '';
|
|
$no_activity = '';
|
|
$city = '';
|
|
$state = '';
|
|
$country = '';
|
|
$thumbnail = '';
|
|
|
|
if(!$text){
|
|
$response_item=array(
|
|
"_id" => $ID,
|
|
"title" => $title,
|
|
"slug" => $slug
|
|
);
|
|
|
|
if(!$algolia){
|
|
$response_item["hasText"] = ($bodylength>0?true:false);
|
|
}
|
|
|
|
$translations = unserialize($translationmeta);
|
|
$translations[LOCALE] = (int)$ID;
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
foreach($translations as $translation_locale=>$translation_id){
|
|
$the_slug = $conference->translation_slug( $translation_locale, $translation_id);
|
|
$row = $the_slug->fetch(PDO::FETCH_ASSOC);
|
|
$translations[$translation_locale.'_slug'] = $row['slug'];
|
|
}
|
|
|
|
$confmeta = $conference->conference_meta( $original_id );
|
|
|
|
extract($confmeta);
|
|
|
|
$response_item['date'] = (new DateTime($date, new DateTimeZone('America/Bogota')))->format('Y-m-d');
|
|
$response_item['timestamp'] = (new DateTime($date, new DateTimeZone('America/Bogota')))->getTimestamp();
|
|
$response_item['activity'] = $no_activity;
|
|
$response_item['city'] = $city;
|
|
$response_item['state'] = $state;
|
|
$response_item['country'] = $country;
|
|
if(!$algolia){
|
|
$response_item['private'] = $private;
|
|
}
|
|
$response_item['thumbnail'] = $thumbnail;
|
|
|
|
if(!$algolia){
|
|
$dt = new DateTime($date);
|
|
$formatter = new IntlDateFormatter(LOCALE, IntlDateFormatter::SHORT, IntlDateFormatter::SHORT);
|
|
$formatter->setPattern( datePattern( $date ) );
|
|
$response_item['nicedate'] = ucfirst($formatter->format($dt));
|
|
$response_item['location'] = implode(', ',array_filter(array($city,$state,Locale::getDisplayRegion('-'.strtoupper($country), LOCALE ))));
|
|
}
|
|
$response_item['duration'] = gmdate("H:i:s", (int)$duration);
|
|
|
|
if( !EXPORT && !$algolia ){
|
|
$fileData = $conference->get_post_files( $ID, LOCALE );
|
|
$files = $fileData->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$response_item['files'] = [];
|
|
|
|
$response_item['files']['youtube'] = str_replace( 'http://', 'https://', $files['youtube']);
|
|
|
|
if($files['videofile'] != ''){
|
|
$response_item['files']['video'] = $conference->get_post_file($files['videofile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['video'] == ''){
|
|
$response_item['files']['video'] = str_replace( 'http://', 'https://',$files['video']);
|
|
}
|
|
} else {
|
|
$response_item['files']['video'] = str_replace( 'http://', 'https://',$files['video']);
|
|
}
|
|
|
|
if($files['audiofile'] != ''){
|
|
$response_item['files']['audio'] = $conference->get_post_file($files['audiofile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['audio'] == ''){
|
|
$response_item['files']['audio'] = str_replace( 'http://', 'https://',$files['audio']);
|
|
}
|
|
} else {
|
|
$response_item['files']['audio'] = str_replace( 'http://', 'https://',$files['audio']);
|
|
}
|
|
|
|
if($files['pdffile'] != ''){
|
|
$response_item['files']['pdf'] = $conference->get_post_file($files['pdffile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['pdf'] == ''){
|
|
$response_item['files']['pdf'] = str_replace( 'http://', 'https://',$files['pdf']);
|
|
}
|
|
} else {
|
|
$response_item['files']['pdf'] = str_replace( 'http://', 'https://',$files['pdf']);
|
|
}
|
|
|
|
if($files['pdfsimplefile'] != ''){
|
|
$response_item['files']['pdf_simple'] = $conference->get_post_file($files['pdfsimplefile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['pdf_simple'] == ''){
|
|
$response_item['files']['pdf_simple'] = str_replace( 'http://', 'https://',$files['pdf_simple']);
|
|
}
|
|
} else {
|
|
$response_item['files']['pdf_simple'] = str_replace( 'http://', 'https://',$files['pdf_simple']);
|
|
}
|
|
|
|
//Image metadata for thumbnail use. TODO: Optimize this return array
|
|
if(!$algolia){
|
|
$response_item['meta'] = unserialize($meta);
|
|
}
|
|
|
|
$imeta = unserialize($meta);
|
|
$images = [];
|
|
$images['small'] = explode('.',$imeta['file'])[0].'-'.$imeta['sizes']['medium']['width'].'x'.$imeta['sizes']['medium']['height'].'.'.explode('.',$imeta['file'])[1];
|
|
$images['medium'] = explode('.',$imeta['file'])[0].'-'.$imeta['sizes']['medium_large']['width'].'x'.$imeta['sizes']['medium_large']['height'].'.'.explode('.',$imeta['file'])[1];
|
|
$images['large'] = explode('.',$imeta['file'])[0].'-'.$imeta['sizes']['large']['width'].'x'.$imeta['sizes']['large']['height'].'.'.explode('.',$imeta['file'])[1];
|
|
$images['original'] = $imeta['file'];
|
|
if(!$algolia){
|
|
$response_item['images'] = $images;
|
|
}
|
|
} else {
|
|
$response_item['body'] = wpautop( $content );
|
|
}
|
|
|
|
$response_item['translations'] = $translations;
|
|
|
|
} else {
|
|
$response_item=[];
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
$confmeta = $conference->conference_meta( $original_id );
|
|
|
|
extract($confmeta);
|
|
|
|
$response_item['_id'] = $ID;
|
|
$response_item['title'] = $title;
|
|
$response_item['date'] = (new DateTime($date, new DateTimeZone('America/Bogota')))->format('Y-m-d');
|
|
$response_item['activity'] = $no_activity;
|
|
$response_item['duration'] = (int)$duration;
|
|
$response_item['duration_hms'] = format_time((int)$duration);
|
|
$response_item['rm'] = $private;
|
|
$response_item['city'] = $city;
|
|
$response_item['state'] = $state;
|
|
$response_item['country'] = $country;
|
|
|
|
$translations = unserialize($translationmeta);
|
|
$translations[LOCALE] = (int)$ID;
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
$tdata = [];
|
|
|
|
foreach($translations as $translation_locale=>$translation_id){
|
|
$messagedata = $conference->detail($translation_id,$translation_locale);
|
|
$message = $messagedata->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$translation = [];
|
|
$translation['languages_code'] = fixLocale($translation_locale);
|
|
$translation['title'] = $message['title'];
|
|
$translation['slug'] = $message['slug'];
|
|
|
|
/*$html = wpautop( $message['content'] );
|
|
$converter = new Markdownify\ConverterExtra;
|
|
$translation['text'] = $converter->parseString($html);*/
|
|
|
|
array_push($tdata,$translation);
|
|
}
|
|
|
|
$response_item['translations'] = $tdata;
|
|
|
|
}
|
|
|
|
if($algolia){
|
|
$response_item['body'] = wpautop( $content );
|
|
if( $response_item['body'] != '' ){
|
|
array_push($data, $response_item);
|
|
}
|
|
} else {
|
|
array_push($conferences_arr, $response_item);
|
|
}
|
|
}
|
|
}
|
|
|
|
if(!$algolia){
|
|
$data = array(
|
|
'count' => $num,
|
|
'result' => array (
|
|
'conferencias' => $conferences_arr
|
|
)
|
|
);
|
|
}
|
|
|
|
echo json_encode($data);
|
|
die();
|
|
|
|
return $data;
|
|
}
|
|
|
|
/**
|
|
* Generate conference list
|
|
*/
|
|
function build_conferences_list( $year, $month, $last_update, $text, $algolia = false ){
|
|
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
|
|
$data = [];
|
|
|
|
if( EXPORT || $algolia){
|
|
$gettext = true;
|
|
} else {
|
|
$gettext = $text;
|
|
}
|
|
|
|
if( RELEVANT ){
|
|
$stmt = $conference->translation_list( $year, $month, $last_update, $gettext, LOCALE, 'relevantes' );
|
|
} else {
|
|
$stmt = $conference->translation_list( $year, $month, $last_update, $gettext, LOCALE );
|
|
}
|
|
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
$conferences_arr=array();
|
|
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
extract($row);
|
|
|
|
$date = '';
|
|
$no_activity = '';
|
|
$city = '';
|
|
$state = '';
|
|
$country = '';
|
|
$thumbnail = '';
|
|
|
|
if(!$text){
|
|
$response_item=array(
|
|
"id" => $ID,
|
|
"locale" => fixLocale(LOCALE),
|
|
"type" => "conference"
|
|
);
|
|
|
|
$translations = unserialize($translationmeta);
|
|
$newtranslations = [];
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
foreach($translations as $translation_locale=>$translation_id){
|
|
$t = [];
|
|
$t['locale'] = fixLocale($translation_locale);
|
|
$t['id'] = $translation_id;
|
|
array_push($newtranslations,$t);
|
|
}
|
|
|
|
$confmeta = $conference->conference_meta( $original_id );
|
|
|
|
extract($confmeta);
|
|
|
|
$response_item['date'] = (new DateTime($date, new DateTimeZone('America/Bogota')))->format('Y-m-d');
|
|
$response_item['activity'] = $no_activity;
|
|
$response_item['place'] = "";
|
|
$response_item['city'] = $city;
|
|
$response_item['state'] = $state;
|
|
$response_item['country'] = $country;
|
|
$response_item['rm'] = $private;
|
|
$response_item['biblestudy'] = '';
|
|
$response_item['duration'] = (int)$duration;
|
|
$response_item['thumbnail'] = $thumbnail;
|
|
|
|
|
|
if( !EXPORT && !$algolia ){
|
|
$fileData = $conference->get_post_files( $ID, LOCALE );
|
|
$files = $fileData->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$response_item['files'] = [];
|
|
|
|
$response_item['files']['youtube'] = str_replace( 'http://', 'https://', $files['youtube']);
|
|
|
|
if($files['videofile'] != ''){
|
|
$response_item['files']['video'] = $conference->get_post_file($files['videofile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['video'] == ''){
|
|
$response_item['files']['video'] = str_replace( 'http://', 'https://',$files['video']);
|
|
}
|
|
} else {
|
|
$response_item['files']['video'] = str_replace( 'http://', 'https://',$files['video']);
|
|
}
|
|
|
|
if($files['audiofile'] != ''){
|
|
$response_item['files']['audio'] = $conference->get_post_file($files['audiofile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['audio'] == ''){
|
|
$response_item['files']['audio'] = str_replace( 'http://', 'https://',$files['audio']);
|
|
}
|
|
} else {
|
|
$response_item['files']['audio'] = str_replace( 'http://', 'https://',$files['audio']);
|
|
}
|
|
|
|
if($files['pdffile'] != ''){
|
|
$response_item['files']['booklet'] = $conference->get_post_file($files['pdffile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['booklet'] == ''){
|
|
$response_item['files']['booklet'] = str_replace( 'http://', 'https://',$files['pdf']);
|
|
}
|
|
} else {
|
|
$response_item['files']['booklet'] = str_replace( 'http://', 'https://',$files['pdf']);
|
|
}
|
|
|
|
if($files['pdfsimplefile'] != ''){
|
|
$response_item['files']['simple'] = $conference->get_post_file($files['pdfsimplefile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['simple'] == ''){
|
|
$response_item['files']['simple'] = str_replace( 'http://', 'https://',$files['pdf_simple']);
|
|
}
|
|
} else {
|
|
$response_item['files']['simple'] = str_replace( 'http://', 'https://',$files['pdf_simple']);
|
|
}
|
|
|
|
} else {
|
|
$response_item['body'] = wpautop( $content );
|
|
}
|
|
|
|
$response_item['translations'] = $newtranslations;
|
|
|
|
$response_item['timestamp'] = (new DateTime($date, new DateTimeZone('America/Bogota')))->getTimestamp();
|
|
|
|
} else {
|
|
$response_item=[];
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
$confmeta = $conference->conference_meta( $original_id );
|
|
|
|
extract($confmeta);
|
|
|
|
$response_item['_id'] = $ID;
|
|
$response_item['title'] = $title;
|
|
$response_item['date'] = (new DateTime($date, new DateTimeZone('America/Bogota')))->format('Y-m-d');
|
|
$response_item['activity'] = $no_activity;
|
|
$response_item['duration'] = (int)$duration;
|
|
$response_item['duration_hms'] = format_time((int)$duration);
|
|
$response_item['rm'] = $private;
|
|
$response_item['city'] = $city;
|
|
$response_item['state'] = $state;
|
|
$response_item['country'] = $country;
|
|
|
|
$translations = unserialize($translationmeta);
|
|
$translations[LOCALE] = (int)$ID;
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
$tdata = [];
|
|
|
|
foreach($translations as $translation_locale=>$translation_id){
|
|
$messagedata = $conference->detail($translation_id,$translation_locale);
|
|
$message = $messagedata->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$translation = [];
|
|
$translation['languages_code'] = fixLocale($translation_locale);
|
|
$translation['title'] = $message['title'];
|
|
$translation['slug'] = $message['slug'];
|
|
|
|
/*$html = wpautop( $message['content'] );
|
|
$converter = new Markdownify\ConverterExtra;
|
|
$translation['text'] = $converter->parseString($html);*/
|
|
|
|
array_push($tdata,$translation);
|
|
}
|
|
|
|
$response_item['translations'] = $tdata;
|
|
|
|
}
|
|
|
|
if($algolia){
|
|
$response_item['body'] = wpautop( $content );
|
|
if( $response_item['body'] != '' ){
|
|
array_push($data, $response_item);
|
|
}
|
|
} else {
|
|
array_push($conferences_arr, $response_item);
|
|
}
|
|
}
|
|
}
|
|
|
|
if( $text ){
|
|
echo json_encode($conferences_arr);
|
|
die();
|
|
}
|
|
|
|
return $conferences_arr;
|
|
}
|
|
|
|
function format_time($t,$f=':'){
|
|
return sprintf("%02d%s%02d%s%02d", floor($t/3600), $f, ($t/60)%60, $f, $t%60);
|
|
}
|
|
|
|
function fixLocale($l){
|
|
switch ($l){
|
|
case "pt_BR":
|
|
case "pt":
|
|
$prefix = "pt";
|
|
break;
|
|
case "en_US":
|
|
case "en":
|
|
$prefix = "en";
|
|
break;
|
|
case "fr_FR":
|
|
case "fr":
|
|
$prefix = "fr";
|
|
break;
|
|
case "es_ES":
|
|
case "es":
|
|
default:
|
|
$prefix = "es";
|
|
break;
|
|
}
|
|
return $prefix;
|
|
}
|
|
|
|
function datePattern( $date ){
|
|
$format = '';
|
|
switch( LOCALE ){
|
|
case "en_US":
|
|
$format = "EEEE, MMMM d, yyyy";
|
|
break;
|
|
case "fr":
|
|
case "pt_BR":
|
|
case "es_ES":
|
|
default:
|
|
$format = "EEEE, d 'de' MMMM 'de' yyyy";
|
|
break;
|
|
}
|
|
return $format;
|
|
}
|
|
|
|
function conference_detail( $id, $showBody=true ){
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
|
|
if(is_numeric($id)){
|
|
$stmt = $conference->detail($id,LOCALE);
|
|
} else {
|
|
$stmt = $conference->detailBySlug($id,LOCALE);
|
|
}
|
|
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
$conferences_arr=array();
|
|
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
|
|
$date = '';
|
|
$no_activity = '';
|
|
$city = '';
|
|
$state = '';
|
|
$country = '';
|
|
$thumbnail = '';
|
|
|
|
extract($row);
|
|
|
|
$response_item=array(
|
|
"id" => $ID,
|
|
"locale" => fixLocale(LOCALE),
|
|
"type" => "conference"
|
|
);
|
|
|
|
$translations = unserialize($translationmeta);
|
|
$newtranslations = [];
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
foreach($translations as $translation_locale=>$translation_id){
|
|
$t = [];
|
|
$t['locale'] = fixLocale($translation_locale);
|
|
$t['id'] = $translation_id;
|
|
array_push($newtranslations,$t);
|
|
}
|
|
|
|
$confmeta = $conference->conference_meta( $original_id );
|
|
|
|
extract($confmeta);
|
|
|
|
$response_item['date'] = (new DateTime($date, new DateTimeZone('America/Bogota')))->format('Y-m-d');
|
|
$response_item['activity'] = $no_activity;
|
|
$response_item['place'] = "";
|
|
$response_item['city'] = $city;
|
|
$response_item['state'] = $state;
|
|
$response_item['country'] = $country;
|
|
$response_item['rm'] = $private;
|
|
$response_item['biblestudy'] = '';
|
|
$response_item['duration'] = (int)$duration;
|
|
$response_item['thumbnail'] = $thumbnail;
|
|
|
|
$fileData = $conference->get_post_files( $ID, LOCALE );
|
|
$files = $fileData->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$response_item['files'] = [];
|
|
|
|
$response_item['files']['youtube'] = str_replace( 'http://', 'https://', $files['youtube']);
|
|
|
|
if($files['videofile'] != ''){
|
|
$response_item['files']['video'] = $conference->get_post_file($files['videofile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['video'] == ''){
|
|
$response_item['files']['video'] = str_replace( 'http://', 'https://',$files['video']);
|
|
}
|
|
} else {
|
|
$response_item['files']['video'] = str_replace( 'http://', 'https://',$files['video']);
|
|
}
|
|
|
|
if($files['audiofile'] != ''){
|
|
$response_item['files']['audio'] = $conference->get_post_file($files['audiofile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['audio'] == ''){
|
|
$response_item['files']['audio'] = str_replace( 'http://', 'https://',$files['audio']);
|
|
}
|
|
} else {
|
|
$response_item['files']['audio'] = str_replace( 'http://', 'https://',$files['audio']);
|
|
}
|
|
|
|
if($files['pdffile'] != ''){
|
|
$response_item['files']['booklet'] = $conference->get_post_file($files['pdffile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['booklet'] == ''){
|
|
$response_item['files']['booklet'] = str_replace( 'http://', 'https://',$files['pdf']);
|
|
}
|
|
} else {
|
|
$response_item['files']['booklet'] = str_replace( 'http://', 'https://',$files['pdf']);
|
|
}
|
|
|
|
if($files['pdfsimplefile'] != ''){
|
|
$response_item['files']['simple'] = $conference->get_post_file($files['pdfsimplefile'], LOCALE)->fetch(PDO::FETCH_ASSOC)['url'];
|
|
if( $response_item['files']['simple'] == ''){
|
|
$response_item['files']['simple'] = str_replace( 'http://', 'https://',$files['pdf_simple']);
|
|
}
|
|
} else {
|
|
$response_item['files']['simple'] = str_replace( 'http://', 'https://',$files['pdf_simple']);
|
|
}
|
|
|
|
$response_item['translations'] = $newtranslations;
|
|
|
|
$response_item['timestamp'] = (new DateTime($date, new DateTimeZone('America/Bogota')))->getTimestamp();
|
|
|
|
|
|
if($showBody){
|
|
$response_item['body'] = wpautop($content);
|
|
}
|
|
|
|
|
|
array_push($conferences_arr, $response_item);
|
|
}
|
|
}
|
|
|
|
|
|
send_response( $conferences_arr );
|
|
}
|
|
|
|
function send_response( $data ){
|
|
// set response code - 200 OK
|
|
header('Content-Type: application/json; charset=utf-8');
|
|
|
|
http_response_code(200);
|
|
|
|
echo json_encode(
|
|
$data, JSON_UNESCAPED_UNICODE
|
|
);
|
|
}
|
|
|
|
function conference_search( $q ){
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
$stmt = $conference->title_search($q, LOCALE);
|
|
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
$conferences_arr=array();
|
|
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
extract($row);
|
|
|
|
$date = '';
|
|
$no_activity = '';
|
|
$city = '';
|
|
$state = '';
|
|
$country = '';
|
|
$thumbnail = '';
|
|
|
|
$response_item=array(
|
|
"_id" => $ID,
|
|
"title" => $title,
|
|
"body" => wpautop($content),
|
|
"slug" => $slug,
|
|
"hasText" => ($bodylength>0?true:false)
|
|
);
|
|
|
|
$translations = unserialize($translationmeta);
|
|
$translations[LOCALE] = (int)$ID;
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
$confmeta = $conference->conference_meta( $original_id );
|
|
|
|
extract($confmeta);
|
|
|
|
$response_item['date'] = $date;
|
|
$response_item['activity'] = $no_activity;
|
|
$response_item['city'] = $city;
|
|
$response_item['state'] = $state;
|
|
$response_item['country'] = $country;
|
|
$response_item['thumbnail'] = $thumbnail;
|
|
|
|
$dt = new DateTime($date);
|
|
$formatter = new IntlDateFormatter(LOCALE, IntlDateFormatter::SHORT, IntlDateFormatter::SHORT);
|
|
$formatter->setPattern( datePattern( $date ) );
|
|
$response_item['nicedate'] = ucfirst($formatter->format($dt));
|
|
$response_item['location'] = implode(', ',array_filter(array($city,$state,Locale::getDisplayRegion('-'.strtoupper($country), LOCALE ))));
|
|
$response_item['duration'] = gmdate("H:i:s", (int)$duration);
|
|
|
|
$fileData = $conference->get_post_files( $ID, LOCALE );
|
|
$files = $fileData->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$response_item['files'] = [];
|
|
|
|
$response_item['files']['youtube'] = str_replace( 'http://', 'https://', $files['youtube']);
|
|
$response_item['files']['video'] = str_replace( 'http://', 'https://',$files['video']);
|
|
$response_item['files']['audio'] = str_replace( 'http://', 'https://',$files['audio']);
|
|
$response_item['files']['pdf'] = str_replace( 'http://', 'https://',$files['pdf']);
|
|
$response_item['files']['pdf_simple'] = str_replace( 'http://', 'https://',$files['pdf_simple']);
|
|
|
|
$response_item['translations'] = $translations;
|
|
|
|
//Image metadata for thumbnail use. TODO: Optimize this return array
|
|
$response_item['meta'] = unserialize($meta);
|
|
|
|
array_push($conferences_arr, $response_item);
|
|
}
|
|
}
|
|
|
|
$data = array(
|
|
'count' => $num,
|
|
'query' => $q,
|
|
'result' => array (
|
|
'conferencias' => $conferences_arr
|
|
)
|
|
);
|
|
|
|
send_response( $data );
|
|
}
|
|
|
|
function conference_content_search( $q ){
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
$stmt = $conference->content_search($q);
|
|
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
$conferences_arr=array();
|
|
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
extract($row);
|
|
|
|
$response_item=array(
|
|
"_id" => $ID,
|
|
"ty" => 'conferencia',
|
|
"d" => date("Y-m-d", strtotime( $creation_date ) ),
|
|
"t" => $title,
|
|
"a" => $no_activity,
|
|
"c" => $city,
|
|
"st" => $state,
|
|
"co" => $country,
|
|
"s" => $duration,
|
|
"sl" => $slug,
|
|
"th" => $thumbnail,
|
|
"ex" => "..." . preg_replace("/\w*?$q\w*/i", '<span class="relevanssi-query-term">$0</span>', better_strip_tags($excerpt)) . "..."
|
|
);
|
|
|
|
$dt = new DateTime($date);
|
|
$formatter = new IntlDateFormatter(LOCALE, IntlDateFormatter::SHORT, IntlDateFormatter::SHORT);
|
|
$formatter->setPattern("EEEE, d 'de' MMMM 'de' yyyy");
|
|
$response_item['date'] = ucfirst($formatter->format($dt));
|
|
$response_item['lo'] = implode(', ',array_filter(array($city,$state,Locale::getDisplayRegion('-'.strtoupper($country), LOCALE ))));
|
|
$response_item['dur'] = gmdate("H:i:s", (int)$duration);
|
|
$response_item['slug'] = 'https://conferenciaswp.carpa.com/conferencias/'.$slug;
|
|
|
|
$fileData = $conference->get_post_files( $ID );
|
|
$files = $fileData->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$response_item['yt'] = str_replace( 'http://', 'https://', $files['youtube']);
|
|
$response_item['v'] = str_replace( 'http://', 'https://',$files['video']);
|
|
$response_item['au'] = str_replace( 'http://', 'https://',$files['audio']);
|
|
$response_item['p'] = str_replace( 'http://', 'https://',$files['pdf']);
|
|
$response_item['ps'] = str_replace( 'http://', 'https://',$files['pdf_simple']);
|
|
|
|
array_push($conferences_arr, $response_item);
|
|
}
|
|
}
|
|
|
|
$data = array(
|
|
'count' => $num,
|
|
'query' => $q,
|
|
'result' => array (
|
|
'conferencias' => $conferences_arr
|
|
)
|
|
);
|
|
|
|
send_response( $data );
|
|
}
|
|
|
|
function countries_list(){
|
|
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
$stmt = $conference->country_summary();
|
|
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
$conferences_arr=array();
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
extract($row);
|
|
|
|
$response_item=array(
|
|
'code' => $row['country_code'],
|
|
'country' => $row['country'],
|
|
'total' => $row['total']
|
|
);
|
|
|
|
array_push($conferences_arr, $response_item);
|
|
}
|
|
}
|
|
|
|
$data = array(
|
|
'count' => $num,
|
|
'countries' => $conferences_arr
|
|
);
|
|
|
|
send_response( $data );
|
|
}
|
|
|
|
function country_conferences($co){
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
$stmt = $conference->country_list($co,LOCALE);
|
|
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
$conferences_arr=array();
|
|
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
extract($row);
|
|
|
|
$date = '';
|
|
$no_activity = '';
|
|
$city = '';
|
|
$state = '';
|
|
$country = '';
|
|
$thumbnail = '';
|
|
|
|
$response_item=array(
|
|
"_id" => $ID,
|
|
"title" => $title,
|
|
"slug" => $slug,
|
|
"hasText" => ($bodylength>0?true:false)
|
|
);
|
|
|
|
$translations = unserialize($translationmeta);
|
|
$translations[LOCALE] = (int)$ID;
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
$confmeta = $conference->conference_meta( $original_id );
|
|
|
|
extract($confmeta);
|
|
|
|
$response_item['date'] = $date;
|
|
$response_item['activity'] = $no_activity;
|
|
$response_item['city'] = $city;
|
|
$response_item['state'] = $state;
|
|
$response_item['country'] = $country;
|
|
$response_item['thumbnail'] = $thumbnail;
|
|
|
|
$dt = new DateTime($date);
|
|
$formatter = new IntlDateFormatter(LOCALE, IntlDateFormatter::SHORT, IntlDateFormatter::SHORT);
|
|
$formatter->setPattern( datePattern( $date ) );
|
|
$response_item['nicedate'] = ucfirst($formatter->format($dt));
|
|
$response_item['location'] = implode(', ',array_filter(array($city,$state,Locale::getDisplayRegion('-'.strtoupper($country), LOCALE ))));
|
|
$response_item['duration'] = gmdate("H:i:s", (int)$duration);
|
|
|
|
$fileData = $conference->get_post_files( $ID, LOCALE );
|
|
$files = $fileData->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$response_item['files'] = [];
|
|
|
|
$response_item['files']['youtube'] = str_replace( 'http://', 'https://', $files['youtube']);
|
|
$response_item['files']['video'] = str_replace( 'http://', 'https://',$files['video']);
|
|
$response_item['files']['audio'] = str_replace( 'http://', 'https://',$files['audio']);
|
|
$response_item['files']['pdf'] = str_replace( 'http://', 'https://',$files['pdf']);
|
|
$response_item['files']['pdf_simple'] = str_replace( 'http://', 'https://',$files['pdf_simple']);
|
|
|
|
//Image metadata for thumbnail use. TODO: Optimize this return array
|
|
$response_item['meta'] = unserialize($meta);
|
|
$response_item['translations'] = $translations;
|
|
|
|
array_push($conferences_arr, $response_item);
|
|
}
|
|
}
|
|
|
|
$data = array(
|
|
'count' => $num,
|
|
'result' => array (
|
|
'conferencias' => $conferences_arr
|
|
)
|
|
);
|
|
|
|
$data['country'] = Locale::getDisplayRegion('-'.strtoupper($country), LOCALE );
|
|
|
|
send_response( $data );
|
|
}
|
|
|
|
function better_strip_tags( $str, $allowable_tags = '', $strip_attrs = false, $preserve_comments = false, callable $callback = null ) {
|
|
$allowable_tags = array_map( 'strtolower', array_filter( // lowercase
|
|
preg_split( '/(?:>|^)\\s*(?:<|$)/', $allowable_tags, -1, PREG_SPLIT_NO_EMPTY ), // get tag names
|
|
function( $tag ) { return preg_match( '/^[a-z][a-z0-9_]*$/i', $tag ); } // filter broken
|
|
) );
|
|
$comments_and_stuff = preg_split( '/(<!--.*?(?:-->|$))/', $str, -1, PREG_SPLIT_DELIM_CAPTURE );
|
|
foreach ( $comments_and_stuff as $i => $comment_or_stuff ) {
|
|
if ( $i % 2 ) { // html comment
|
|
if ( !( $preserve_comments && preg_match( '/<!--.*?-->/', $comment_or_stuff ) ) ) {
|
|
$comments_and_stuff[$i] = '';
|
|
}
|
|
} else { // stuff between comments
|
|
$tags_and_text = preg_split( "/(<(?:[^>\"']++|\"[^\"]*+(?:\"|$)|'[^']*+(?:'|$))*(?:>|$))/", $comment_or_stuff, -1, PREG_SPLIT_DELIM_CAPTURE );
|
|
foreach ( $tags_and_text as $j => $tag_or_text ) {
|
|
$is_broken = false;
|
|
$is_allowable = true;
|
|
$result = $tag_or_text;
|
|
if ( $j % 2 ) { // tag
|
|
if ( preg_match( "%^(</?)([a-z][a-z0-9_]*)\\b(?:[^>\"'/]++|/+?|\"[^\"]*\"|'[^']*')*?(/?>)%i", $tag_or_text, $matches ) ) {
|
|
$tag = strtolower( $matches[2] );
|
|
if ( in_array( $tag, $allowable_tags ) ) {
|
|
if ( $strip_attrs ) {
|
|
$opening = $matches[1];
|
|
$closing = ( $opening === '</' ) ? '>' : $closing;
|
|
$result = $opening . $tag . $closing;
|
|
}
|
|
} else {
|
|
$is_allowable = false;
|
|
$result = '';
|
|
}
|
|
} else {
|
|
$is_broken = true;
|
|
$result = '';
|
|
}
|
|
} else { // text
|
|
$tag = false;
|
|
}
|
|
if ( !$is_broken && isset( $callback ) ) {
|
|
// allow result modification
|
|
call_user_func_array( $callback, array( &$result, $tag_or_text, $tag, $is_allowable ) );
|
|
}
|
|
$tags_and_text[$j] = $result;
|
|
}
|
|
$comments_and_stuff[$i] = implode( '', $tags_and_text );
|
|
}
|
|
}
|
|
$str = implode( '', $comments_and_stuff );
|
|
return $str;
|
|
}
|
|
|
|
function getFilePrefix(){
|
|
switch (LOCALE){
|
|
case "pt_BR":
|
|
case "pt":
|
|
$prefix = "POR";
|
|
break;
|
|
case "en_US":
|
|
case "en":
|
|
$prefix = "ENG";
|
|
break;
|
|
case "fr_FR":
|
|
case "fr":
|
|
$prefix = "FRA";
|
|
break;
|
|
case "es_ES":
|
|
case "es":
|
|
default:
|
|
$prefix = "SPA";
|
|
break;
|
|
}
|
|
return $prefix;
|
|
}
|
|
|
|
function conference_epub($id,$return,$overwrite){
|
|
|
|
require_once( '/var/www/html/v3/inc/epub/EPub.php');
|
|
require_once( '/var/www/html/v3/inc/epub/EPubChapterSplitter.class.php');
|
|
require_once( '/var/www/html/v3/inc/epub/Zip.class.php');
|
|
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
|
|
$stmt = $conference->detail($id,LOCALE);
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
extract($row);
|
|
|
|
$date = '';
|
|
$no_activity = '';
|
|
$city = '';
|
|
$state = '';
|
|
$country = '';
|
|
$thumbnail = '';
|
|
|
|
$response_item=array(
|
|
"_id" => $ID,
|
|
"title" => $title,
|
|
"body" => wpautop($content),
|
|
"slug" => $slug,
|
|
"hasText" => ($bodylength>0?true:false)
|
|
);
|
|
|
|
$translations = unserialize($translationmeta);
|
|
$translations[LOCALE] = (int)$ID;
|
|
|
|
if(LOCALE=='es_ES'){
|
|
$original_id = $ID;
|
|
} else {
|
|
$original_id = $translations['es_ES'];
|
|
}
|
|
|
|
$confmeta = $conference->conference_meta( $original_id );
|
|
|
|
extract($confmeta);
|
|
|
|
$response_item['date'] = $date;
|
|
$response_item['activity'] = $no_activity;
|
|
$response_item['city'] = $city;
|
|
$response_item['state'] = $state;
|
|
$response_item['country'] = $country;
|
|
$response_item['thumbnail'] = $thumbnail;
|
|
|
|
$dt = new DateTime($date);
|
|
$formatter = new IntlDateFormatter(LOCALE, IntlDateFormatter::SHORT, IntlDateFormatter::SHORT);
|
|
$formatter->setPattern( datePattern( $date ) );
|
|
$nicedate = ucfirst($formatter->format($dt));
|
|
$lo = implode(', ',array_filter(array($city,$state,Locale::getDisplayRegion('-'.strtoupper($country), LOCALE ))));
|
|
|
|
$code = getFilePrefix() . '-' . date("Y-m-d", strtotime( $date ) ) . '-' . $no_activity;
|
|
|
|
//Title
|
|
$newTitle = sanitize_title( $title );
|
|
$fixedNewTitle = str_replace( '-','_',$newTitle );
|
|
|
|
$newFilename = $code . "-" . $fixedNewTitle . "-" . strtoupper( substr( $city , 0 , 3 ) ) . strtoupper( $country ) . ".epub";
|
|
|
|
$file = $newFilename;
|
|
|
|
$generate = 'true';
|
|
|
|
if(file_exists( $file )){
|
|
$generate = 'false';
|
|
}
|
|
|
|
if($generate == 'true' || $overwrite == 'true'){
|
|
$book = new EPub();
|
|
|
|
// Title and Identifier are mandatory!
|
|
$book->setTitle( $title );
|
|
$book->setIdentifier( $code , EPub::IDENTIFIER_URI); // Could also be the ISBN number, prefered for published books, or a UUID.
|
|
$book->setLanguage( LOCALE ); // Not needed, but included for the example, Language is mandatory, but EPub defaults to "en". Use RFC3066 Language codes, such as "en", "da", "fr" etc.
|
|
$book->setDescription( $t . ', predicado el ' . $nicedate . ', en ' . $lo );
|
|
$book->setAuthor("Dr. William Soto Santiago","Dr. William Soto Santiago");
|
|
$book->setPublisher("La Gran Carpa Catedral, Corp.", "https://www.carpa.com/"); // I hope this is a non existant address :)
|
|
$book->setDate(time()); // Strictly not needed as the book date defaults to time().
|
|
$book->setRights("Copyright and licence information specific for the book.");
|
|
$book->setSourceURL( $u );
|
|
|
|
$cssData = "
|
|
h1 {\n text-transform : uppercase;\n text-align : center;\n}\n
|
|
h2 {\n text-align : center;\n text-transform : capitalize;\n}";
|
|
|
|
$book->addCSSFile("styles.css", "css1", $cssData);
|
|
|
|
// ePub uses XHTML 1.1, preferably strict.
|
|
$content_start =
|
|
"<?xml version=\"1.0\" encoding=\"utf-8\"?>\n"
|
|
. "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.1//EN\"\n"
|
|
. " \"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd\">\n"
|
|
. "<html xmlns=\"http://www.w3.org/1999/xhtml\">\n"
|
|
. "<head>"
|
|
. "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\n"
|
|
. "<link rel=\"stylesheet\" type=\"text/css\" href=\"styles.css\" />\n"
|
|
. "<title>". $title ."</title>\n"
|
|
. "</head>\n"
|
|
. "<body>\n";
|
|
|
|
$svgData = '<?xml version="1.0" encoding="utf-8"?><svg xmlns="http://www.w3.org/2000/svg" xml:space="preserve" x="0" y="0" version="1.1" viewBox="0 0 710.33 134.1"><path d="M276.83 79.5c-27.61-9.75-78.41-6.39-91.89-.06C242.35 41.14 315.81 8.7 402.17 1.07c17.45-1.38 40.95-1.52 63.71.18C572.97 9.26 658.85 65.5 710.33 134.1 663.2 90.76 585.31 31.86 461.15 31.86c-95.72 0-167.71 38.13-184.32 47.64z" fill="#ed1c24" fill-rule="evenodd" clip-rule="evenodd"/><path d="M91.41 79.44C64.55 68.85 12.87 73.78.52 79.27 70.43 29.73 170.34-3.72 316.7 1.6 178.46 11.28 102.53 72.2 91.41 79.44z" fill="#2d4ea2" fill-rule="evenodd" clip-rule="evenodd"/><path d="M184.94 79.64c-26.86-10.59-81.18-5.69-93.53-.2C161.32 29.9 249.94-6.39 403.56 1.48 294.93 9.2 216.06 60.24 184.94 79.64z" fill="#fff" fill-rule="evenodd" clip-rule="evenodd"/><path d="M0 86.68h7.56v22.68c0 1.66.25 3.03.76 4.13.5 1.1 1.2 1.98 2.08 2.65.88.67 1.92 1.14 3.1 1.43 1.19.29 2.45.43 3.78.43H27v6.48h-9.72c-2.38 0-4.61-.25-6.7-.76-2.09-.5-3.92-1.35-5.48-2.54-1.57-1.19-2.81-2.75-3.73-4.67S0 112.2 0 109.36V86.68z"/><path d="M37.97 97.53h5.81l12.01 26.95h-6.01l-2.27-5.39H34.24l-2.27 5.39h-6.01l12.01-26.95zm7.59 16.94-4.7-11.01-4.66 11.01h9.36zm162.21 8.81c-1.96-.67-3.68-1.74-5.16-3.21-1.48-1.48-2.64-3.42-3.48-5.83-.85-2.41-1.27-5.36-1.27-8.86 0-3.49.42-6.44 1.27-8.86.85-2.41 2.01-4.36 3.48-5.83 1.48-1.48 3.19-2.55 5.16-3.21 1.96-.67 4.06-1 6.29-1h14.04v6.48h-12.96c-1.33 0-2.59.2-3.78.59s-2.22 1.07-3.1 2.02c-.88.95-1.58 2.22-2.08 3.81-.5 1.58-.76 3.58-.76 5.99s.25 4.41.76 5.99c.5 1.58 1.2 2.85 2.08 3.81.88.95 1.92 1.63 3.1 2.02 1.19.4 2.45.59 3.78.59h12.96v6.48h-14.04c-2.23.02-4.33-.31-6.29-.98zm33.88-28.23h6.31l13.03 29.23h-6.51l-2.46-5.85H237.6l-2.46 5.85h-6.52l13.03-29.23zm8.23 18.37-5.09-11.94-5.05 11.94h10.14zm11.73-18.37h17.33c1.28 0 2.49.15 3.63.46 1.14.31 2.14.8 3.01 1.48.86.68 1.54 1.59 2.03 2.71.49 1.13.73 2.5.73 4.11 0 1.42-.17 2.65-.5 3.7s-.8 1.93-1.4 2.65c-.6.72-1.31 1.29-2.13 1.71-.82.42-1.71.72-2.65.92l6.64 11.48h-6.77L275.35 113h-7.89v11.28h-5.85V95.05zm17.33 12.94c.97 0 1.81-.3 2.51-.9.7-.6 1.04-1.69 1.04-3.28 0-1.39-.35-2.37-1.04-2.92-.7-.56-1.53-.83-2.51-.83h-11.48V108h11.48zm12.74-12.94h16.91c1.34 0 2.6.17 3.8.5 1.2.33 2.24.88 3.13 1.63.89.75 1.59 1.74 2.11 2.97.51 1.23.77 2.73.77 4.51 0 1.92-.26 3.52-.77 4.8-.52 1.28-1.22 2.31-2.11 3.09-.89.78-1.94 1.33-3.13 1.65-1.2.32-2.46.48-3.8.48h-11.07v9.61h-5.85V95.05zm16.91 14.61c.53 0 1.04-.08 1.52-.25.49-.17.91-.44 1.27-.81.36-.38.65-.88.86-1.52.21-.64.31-1.45.31-2.42 0-1.67-.39-2.85-1.17-3.55-.78-.7-1.71-1.04-2.8-1.04h-11.07v9.61h11.08zm19.38-14.61h6.31l13.03 29.23h-6.51l-2.46-5.85h-14.41l-2.46 5.85h-6.52l13.02-29.23zm8.23 18.37-5.09-11.94-5.05 11.94h10.14zm29.09 10.19c-1.96-.67-3.68-1.74-5.16-3.21-1.48-1.48-2.64-3.42-3.48-5.83-.85-2.41-1.27-5.36-1.27-8.86 0-3.49.42-6.44 1.27-8.86.85-2.41 2.01-4.36 3.48-5.83 1.48-1.48 3.19-2.55 5.16-3.21 1.96-.67 4.06-1 6.29-1h14.04v6.48h-12.96c-1.33 0-2.59.2-3.78.59-1.19.4-2.22 1.07-3.11 2.02-.88.95-1.58 2.22-2.08 3.81-.5 1.58-.76 3.58-.76 5.99s.25 4.41.76 5.99c.5 1.58 1.2 2.85 2.08 3.81.88.95 1.92 1.63 3.11 2.02 1.19.4 2.45.59 3.78.59h12.96v6.48h-14.04c-2.24.02-4.33-.31-6.29-.98zm33.87-28.23h6.31l13.03 29.23h-6.52l-2.46-5.85h-14.41l-2.46 5.85h-6.51l13.02-29.23zm8.23 18.37-5.09-11.94-5.05 11.94h10.14zm15.99-13.36h-10.44v-5.01h26.73v5.01h-10.44v24.22h-5.85v-24.22zm23.99 23.45c-1.52-.51-2.85-1.34-3.99-2.49-1.14-1.14-2.04-2.64-2.69-4.51-.65-1.87-.98-4.15-.98-6.85 0-2.7.33-4.98.98-6.85.65-1.87 1.55-3.37 2.69-4.51 1.14-1.14 2.47-1.97 3.99-2.48 1.52-.52 3.14-.77 4.87-.77h10.86v5.01h-10.02c-.92 0-1.78.12-2.59.36-.81.24-1.54.63-2.19 1.17-.65.54-1.21 1.27-1.67 2.17-.46.91-.77 2.04-.94 3.4h17.42v5.01h-17.42c.17 1.36.48 2.5.94 3.4.46.91 1.02 1.63 1.67 2.17.65.54 1.38.93 2.19 1.17.81.24 1.67.35 2.59.35h10.02v5.01h-10.86c-1.73.01-3.35-.25-4.87-.76zm19.7-28.46h14.2c1.73 0 3.35.26 4.87.77s2.85 1.34 3.99 2.48c1.14 1.14 2.04 2.65 2.69 4.51.65 1.87.98 4.15.98 6.85 0 2.7-.33 4.98-.98 6.85-.66 1.87-1.55 3.37-2.69 4.51a10.276 10.276 0 0 1-3.99 2.49c-1.52.52-3.14.77-4.87.77h-14.2V95.38zm13.36 24.22c1.03 0 2-.15 2.92-.46.92-.31 1.72-.83 2.4-1.57.68-.74 1.22-1.72 1.61-2.94.39-1.22.58-2.77.58-4.64 0-1.87-.2-3.41-.58-4.64-.39-1.22-.93-2.21-1.61-2.94a5.673 5.673 0 0 0-2.4-1.57c-.92-.31-1.89-.46-2.92-.46h-7.52v19.21h7.52zm16.08-24.22h17.33c1.28 0 2.49.15 3.63.46 1.14.31 2.14.8 3.01 1.48.86.68 1.54 1.59 2.03 2.71.49 1.13.73 2.5.73 4.11 0 1.42-.17 2.65-.5 3.7-.33 1.04-.8 1.93-1.4 2.65-.6.72-1.31 1.29-2.13 1.71-.82.42-1.71.72-2.65.92l6.64 11.48h-6.77l-6.18-11.28h-7.89v11.28h-5.85V95.38zm17.33 12.94c.97 0 1.81-.3 2.51-.9.7-.6 1.04-1.69 1.04-3.28 0-1.39-.35-2.37-1.04-2.92-.7-.56-1.53-.83-2.51-.83h-11.48v7.94h11.48zm22.43-12.94h6.31l13.03 29.23h-6.52l-2.46-5.85h-14.41l-2.46 5.85h-6.51l13.02-29.23zm8.22 18.37-5.09-11.94-5.05 11.94h10.14zm11.32-18.37h5.85v17.54c0 1.28.2 2.35.59 3.19.39.85.93 1.53 1.61 2.05.68.52 1.48.88 2.4 1.11.92.22 1.89.33 2.92.33h7.52v5.01h-7.52c-1.84 0-3.56-.19-5.18-.58-1.62-.39-3.03-1.04-4.24-1.96-1.21-.92-2.17-2.12-2.88-3.61-.71-1.49-1.07-3.33-1.07-5.53V95.38zm42.7 25.72c-.92-.31-1.72-.81-2.4-1.5-.69-.69-1.23-1.59-1.62-2.72-.39-1.12-.59-2.5-.59-4.13s.2-3 .59-4.13c.39-1.12.93-2.03 1.62-2.72.69-.69 1.49-1.19 2.4-1.5.91-.31 1.89-.47 2.93-.47h6.54v3.02h-6.04c-.62 0-1.21.09-1.76.28-.55.18-1.04.5-1.45.94-.41.44-.73 1.04-.97 1.77-.24.74-.35 1.67-.35 2.79s.12 2.05.35 2.79c.23.74.56 1.33.97 1.77.41.44.89.76 1.45.94.55.18 1.14.28 1.76.28h6.04v3.02h-6.54c-1.04.04-2.01-.12-2.93-.43zm11.49-8.34c0-1.69.22-3.13.67-4.3.44-1.17 1.05-2.12 1.82-2.84.77-.72 1.68-1.24 2.72-1.56 1.04-.32 2.16-.48 3.35-.48 1.16 0 2.26.16 3.3.48 1.04.32 1.95.84 2.73 1.56.78.72 1.4 1.67 1.85 2.84.45 1.17.68 2.61.68 4.3s-.23 3.13-.68 4.3c-.45 1.17-1.07 2.12-1.85 2.84-.78.72-1.69 1.24-2.73 1.56-1.04.32-2.14.48-3.3.48-1.19 0-2.31-.16-3.35-.48s-1.95-.84-2.72-1.56c-.77-.72-1.38-1.67-1.82-2.84-.45-1.17-.67-2.61-.67-4.3zm8.56 6.16c.69 0 1.34-.1 1.95-.29.61-.19 1.14-.52 1.6-.99s.81-1.1 1.08-1.9c.27-.8.4-1.79.4-2.98s-.13-2.19-.4-2.98-.63-1.43-1.08-1.9c-.45-.47-.99-.8-1.6-.99-.61-.19-1.26-.29-1.95-.29-.71 0-1.36.1-1.98.29-.61.19-1.15.52-1.6.99-.45.47-.81 1.1-1.07 1.9s-.39 1.79-.39 2.98.13 2.19.39 2.98c.26.8.62 1.43 1.07 1.9.45.47.99.8 1.6.99.61.2 1.27.29 1.98.29zm10.82-14.97h10.44c.77 0 1.5.09 2.19.28.69.18 1.29.48 1.81.89.52.41.93.96 1.22 1.64.29.68.44 1.51.44 2.48 0 .86-.1 1.6-.3 2.23-.2.63-.48 1.16-.84 1.6-.36.44-.79.78-1.28 1.03-.5.25-1.03.44-1.6.55l4 6.92h-4.08l-3.72-6.79h-4.76v6.79h-3.52v-17.62zm10.44 7.8c.59 0 1.09-.18 1.51-.54.42-.36.63-1.02.63-1.98 0-.84-.21-1.43-.63-1.76-.42-.33-.92-.5-1.51-.5h-6.92v4.78h6.92zm8.31-7.8h10.19c.8 0 1.57.1 2.29.3.72.2 1.35.53 1.89.98.54.45.96 1.05 1.27 1.79s.47 1.64.47 2.72c0 1.16-.16 2.12-.47 2.89s-.73 1.39-1.27 1.86c-.54.47-1.17.8-1.89.99-.72.19-1.49.29-2.29.29h-6.67v5.79h-3.52v-17.61zm10.19 8.81c.32 0 .63-.05.92-.15.29-.1.55-.26.77-.49.22-.23.39-.53.52-.92s.19-.87.19-1.46c0-1.01-.24-1.72-.71-2.14-.47-.42-1.03-.63-1.69-.63h-6.67v5.79h6.67zm.66 6.1h4.01v4.01h-4.01v-4.01zm-585.61 4.68c-1.96-.67-3.68-1.74-5.16-3.21-1.48-1.48-2.64-3.42-3.48-5.83-.85-2.41-1.27-5.36-1.27-8.86 0-3.49.42-6.44 1.27-8.86.85-2.41 2.01-4.36 3.48-5.83 1.48-1.48 3.19-2.55 5.16-3.21 1.96-.67 4.06-1 6.29-1h18.36v6.48H80.75c-1.33 0-2.59.2-3.78.59s-2.22 1.07-3.1 2.02c-.88.95-1.58 2.22-2.08 3.81-.5 1.58-.76 3.58-.76 5.99s.25 4.41.76 5.99c.5 1.58 1.2 2.85 2.08 3.81.88.95 1.92 1.63 3.1 2.02 1.19.4 2.45.59 3.78.59h9.72v-9.18h-7.56v-6.48h15.12v22.14H79.67c-2.24.02-4.33-.32-6.3-.98zm28.98-27.42h16.85c1.24 0 2.42.15 3.53.45 1.11.3 2.08.78 2.92 1.44.84.66 1.5 1.54 1.97 2.64s.71 2.43.71 4c0 1.38-.16 2.58-.49 3.59-.32 1.01-.78 1.87-1.36 2.58-.58.7-1.27 1.26-2.07 1.66-.8.41-1.66.7-2.58.89l6.46 11.17h-6.58l-6.01-10.96h-7.67v10.96h-5.68V96.12zm16.85 12.58c.95 0 1.76-.29 2.44-.87.68-.58 1.01-1.64 1.01-3.19 0-1.35-.34-2.3-1.01-2.84-.68-.54-1.49-.81-2.44-.81h-11.17v7.71h11.17zM141 96.12h6.13l12.67 28.42h-6.33l-2.4-5.68h-14.01l-2.4 5.68h-6.33L141 96.12zm8 17.86-4.95-11.61-4.91 11.61H149zm11.41-17.86h7.31l11.37 20.67V96.12h5.68v28.42h-7.31l-11.37-20.67v20.67h-5.68V96.12zm421.96 34.28v-3.77h-2.24v-5h4.8v3.63c0 1.09-.21 2.05-.62 2.86s-1.05 1.58-1.94 2.28z"/></svg>';
|
|
|
|
$book->addFile("logo_lgccc_epub.svg", "logo_svg", $svgData, "image/svg+xml");
|
|
|
|
$cover = $content_start . "<h6>".$code."</h6><h1>".$title."</h1>\n<h2>Dr. William Soto Santiago<br/>".$nicedate."<br/>" . $lo . "</h2><br/><div style=\"text-align:center;width:60%;margin:0 auto;margin-top:100px;\"><img alt=\"La Gran Carpa Catedral Corp.\" src=\"logo_lgccc_epub.svg\" style=\"width:60%;\"/></div>\n"
|
|
. "</body>\n</html>\n";
|
|
$book->addChapter("Cover", "Cover.html", $cover);
|
|
|
|
$content = autop($content);
|
|
|
|
$content = preg_replace('/[\x00-\x1F\x7F]/u', '', $content);
|
|
|
|
$contenido = $content_start . "<h1>".$title."</h1>\n<h2>Dr. William Soto Santiago<br/>".$nicedate."<br/>" . $lo . "</h2>\n" . $content
|
|
. "</body>\n</html>\n";;
|
|
|
|
$book->addChapter("Contenido: " . $title, "Chapter001.html", $contenido);
|
|
|
|
$book->finalize(); // Finalize the book, and build the archive.
|
|
|
|
//save file
|
|
$fp = fopen( $file , 'w');
|
|
fwrite( $fp , $book->getBook() );
|
|
fclose( $fp );
|
|
|
|
if($return=='true'){
|
|
$zipData = $book->sendBook( $newFilename );
|
|
}
|
|
|
|
//die();
|
|
} else {
|
|
|
|
if($return=='true'){
|
|
$newTitle = sanitize_title( $title );
|
|
$fixedNewTitle = str_replace( '-','_',$newTitle );
|
|
|
|
$newFilename = $code . "-" . $fixedNewTitle . "-" . strtoupper( substr( $city , 0 , 3 ) ) . strtoupper( $country ) . ".epub";
|
|
|
|
//Send current file
|
|
header($_SERVER["SERVER_PROTOCOL"] . " 200 OK");
|
|
header("Cache-Control: public"); // needed for internet explorer
|
|
header("Content-Type: application/epub+zip");
|
|
header("Content-Transfer-Encoding: Binary");
|
|
header("Content-Length:".filesize($file));
|
|
header("Content-Disposition: attachment; filename=".$newFilename);
|
|
readfile($file);
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
}
|
|
}
|
|
|
|
function sanitize_title($text, string $divider = '-') {
|
|
// replace non letter or digits by divider
|
|
$text = preg_replace('~[^\pL\d]+~u', $divider, $text);
|
|
|
|
// transliterate
|
|
$text = iconv('utf-8', 'us-ascii//TRANSLIT', $text);
|
|
|
|
// remove unwanted characters
|
|
$text = preg_replace('~[^-\w]+~', '', $text);
|
|
|
|
// trim
|
|
$text = trim($text, $divider);
|
|
|
|
// remove duplicate divider
|
|
$text = preg_replace('~-+~', $divider, $text);
|
|
|
|
// lowercase
|
|
$text = strtolower($text);
|
|
|
|
if (empty($text)) {
|
|
return 'n-a';
|
|
}
|
|
|
|
return $text;
|
|
}
|
|
|
|
function nl2p($string, $line_breaks = false, $xml = true) {
|
|
|
|
$string = str_replace(array('<p>', '</p>', '<br>', '<br />'), '', $string);
|
|
|
|
// It is conceivable that people might still want single line-breaks
|
|
// without breaking into a new paragraph.
|
|
if ($line_breaks == true)
|
|
return '<p>'.preg_replace(array("/([\n]{2,})/i", "/([^>])\n([^<])/i"), array("</p>\n<p>", '$1<br'.($xml == true ? ' /' : '').'>$2'), trim($string)).'</p>';
|
|
else
|
|
return '<p>'.preg_replace(
|
|
array("/([\n]{2,})/i", "/([\r\n]{3,})/i","/([^>])\n([^<])/i"),
|
|
array("</p>\n<p>", "</p>\n<p>", '$1<br'.($xml == true ? ' /' : '').'>$2'),
|
|
|
|
trim($string)).'</p>';
|
|
}
|
|
|
|
function autop($pee, $br = false) {
|
|
$pre_tags = array();
|
|
|
|
if ( trim($pee) === '' )
|
|
return '';
|
|
|
|
$pee = $pee . "\n"; // just to make things a little easier, pad the end
|
|
|
|
if ( strpos($pee, '<pre') !== false ) {
|
|
$pee_parts = explode( '</pre>', $pee );
|
|
$last_pee = array_pop($pee_parts);
|
|
$pee = '';
|
|
$i = 0;
|
|
|
|
foreach ( $pee_parts as $pee_part ) {
|
|
$start = strpos($pee_part, '<pre');
|
|
|
|
// Malformed html?
|
|
if ( $start === false ) {
|
|
$pee .= $pee_part;
|
|
continue;
|
|
}
|
|
|
|
$name = "<pre wp-pre-tag-$i></pre>";
|
|
$pre_tags[$name] = substr( $pee_part, $start ) . '</pre>';
|
|
|
|
$pee .= substr( $pee_part, 0, $start ) . $name;
|
|
$i++;
|
|
}
|
|
|
|
$pee .= $last_pee;
|
|
}
|
|
|
|
$pee = preg_replace('|<br />\s*<br />|', "\n\n", $pee);
|
|
// Space things out a little
|
|
$allblocks = '(?:table|thead|tfoot|caption|col|colgroup|tbody|tr|td|th|div|dl|dd|dt|ul|ol|li|pre|select|option|form|map|area|blockquote|address|math|style|p|h[1-6]|hr|fieldset|noscript|samp|legend|section|article|aside|hgroup|header|footer|nav|figure|figcaption|details|menu|summary)';
|
|
$pee = preg_replace('!(<' . $allblocks . '[^>]*>)!', "\n$1", $pee);
|
|
$pee = preg_replace('!(</' . $allblocks . '>)!', "$1\n\n", $pee);
|
|
$pee = str_replace(array("\r\n", "\r"), "\n", $pee); // cross-platform newlines
|
|
if ( strpos($pee, '<object') !== false ) {
|
|
$pee = preg_replace('|\s*<param([^>]*)>\s*|', "<param$1>", $pee); // no pee inside object/embed
|
|
$pee = preg_replace('|\s*</embed>\s*|', '</embed>', $pee);
|
|
}
|
|
$pee = preg_replace("/\n\n+/", "\n\n", $pee); // take care of duplicates
|
|
// make paragraphs, including one at the end
|
|
$pees = preg_split('/\n\s*\n/', $pee, -1, PREG_SPLIT_NO_EMPTY);
|
|
$pee = '';
|
|
foreach ( $pees as $tinkle )
|
|
$pee .= '<p>' . trim($tinkle, "\n") . "</p>\n";
|
|
$pee = preg_replace('|<p>\s*</p>|', '', $pee); // under certain strange conditions it could create a P of entirely whitespace
|
|
$pee = preg_replace('!<p>([^<]+)</(div|address|form)>!', "<p>$1</p></$2>", $pee);
|
|
$pee = preg_replace('!<p>\s*(</?' . $allblocks . '[^>]*>)\s*</p>!', "$1", $pee); // don't pee all over a tag
|
|
$pee = preg_replace("|<p>(<li.+?)</p>|", "$1", $pee); // problem with nested lists
|
|
$pee = preg_replace('|<p><blockquote([^>]*)>|i', "<blockquote$1><p>", $pee);
|
|
$pee = str_replace('</blockquote></p>', '</p></blockquote>', $pee);
|
|
$pee = preg_replace('!<p>\s*(</?' . $allblocks . '[^>]*>)!', "$1", $pee);
|
|
$pee = preg_replace('!(</?' . $allblocks . '[^>]*>)\s*</p>!', "$1", $pee);
|
|
if ( $br ) {
|
|
$pee = preg_replace_callback('/<(script|style).*?<\/\\1>/s', create_function('$matches', 'return str_replace("\n", "<PreserveNewline />", $matches[0]);'), $pee);
|
|
$pee = preg_replace('|(?<!<br />)\s*\n|', "<br />\n", $pee); // optionally make line breaks
|
|
$pee = str_replace('<PreserveNewline />', "\n", $pee);
|
|
}
|
|
$pee = preg_replace('!(</?' . $allblocks . '[^>]*>)\s*<br />!', "$1", $pee);
|
|
$pee = preg_replace('!<br />(\s*</?(?:p|li|div|dl|dd|dt|th|pre|td|ul|ol)[^>]*>)!', '$1', $pee);
|
|
$pee = preg_replace( "|\n</p>$|", '</p>', $pee );
|
|
|
|
if ( !empty($pre_tags) )
|
|
$pee = str_replace(array_keys($pre_tags), array_values($pre_tags), $pee);
|
|
|
|
return $pee;
|
|
}
|
|
|
|
function conference_download($h,$p,$file){
|
|
header_remove();
|
|
header("X-Accel-Redirect: /downloadfile/" . $h . $p .'?' . $file);
|
|
}
|
|
|
|
function last_updated(){
|
|
|
|
}
|
|
|
|
function conference_years(){
|
|
|
|
$database = new Database();
|
|
$db = $database->getConnection();
|
|
|
|
$conference = new Conferencia($db);
|
|
$stmt = $conference->year_list(LOCALE);
|
|
|
|
$num = $stmt->rowCount();
|
|
|
|
if($num>0){
|
|
$conferences_arr=array();
|
|
|
|
$years = [];
|
|
$formattedYears = [];
|
|
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
|
|
extract($row);
|
|
|
|
if ($currentYear != $year){
|
|
$currentYear = $year;
|
|
$years[$currentYear] = [];
|
|
}
|
|
|
|
$format = new IntlDateFormatter(LOCALE, IntlDateFormatter::NONE, IntlDateFormatter::NONE, NULL, NULL, "MMMM");
|
|
$monthName = datefmt_format($format, mktime(0, 0, 0, $month));
|
|
|
|
array_push( $years[$currentYear], array('name'=>$monthName,'month'=>str_pad($month,2,'0',STR_PAD_LEFT),'count' => $total));
|
|
|
|
}
|
|
}
|
|
|
|
$newYears = [];
|
|
|
|
foreach($years as $year=>$months){
|
|
$totalyear = 0;
|
|
foreach($months as $month=>$count){
|
|
$totalyear += $count['count'];
|
|
}
|
|
array_push($newYears, array('year'=>$year, 'count'=>$totalyear, 'months' => $months));
|
|
}
|
|
|
|
$data = array(
|
|
'result' => array (
|
|
'years' => $newYears
|
|
)
|
|
);
|
|
|
|
|
|
send_response( $data );
|
|
} |