public function music($alias)
{
if (empty($alias)) {
echo 'redirection somewhere';
} else {
$query = $this->music->find_user_list_by_alias($alias);
if (!$query) {
echo 'you are the loser';
} else {
$this->load->helper('create_xml');
$user = $this->user->find($this->get_user_id());
create_xml($query, $user->alias);
$this->load->view('play/music');
}
}
}
function get_data($table, $format, $mysql)
{
//получаем данные из выбранной таблицы
$query = "SELECT * FROM {$table}";
$result = $mysql->query($query);
$data = $result->fetch_all(MYSQL_ASSOC);
//проверка формата для вызова соответствующей функции генерирования файла
switch ($format) {
case "CSV":
create_csv($table, $data, $mysql);
break;
case "JSON":
create_json($table, $data, $mysql);
break;
case "XML":
create_xml($table, $data, $mysql);
break;
default:
echo "<h3>Выберите нужный формат из списка!</h3>";
}
}
// Проверка корректности таблицы
if (in_array($table, $allow_tables)) {
try {
$stmt = $pdo->query("SELECT * FROM {$table}");
// Получаем имена столбцов
$keys_stmt = $pdo->query("SHOW COLUMNS FROM {$table}");
} catch (PDOException $e) {
die("Ошибка выполенения запроса: " . $e->getMessage());
}
} else {
die("Неверно указана таблица");
}
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
$keys = $keys_stmt->fetchAll(PDO::FETCH_ASSOC);
unset($pdo);
$keys_array = array();
foreach ($keys as $key) {
$keys_array[] = $key['Field'];
}
switch ($format) {
case 'csv':
$filename = create_csv($data, $keys_array, $filepath);
break;
case 'json':
$filename = create_json($data, $filepath);
break;
case 'xml':
$filename = create_xml($data, $keys_array, $filepath, $table);
break;
}
file_download($filepath);
function do_addform($object, $class, $dttype = null, $notitleflag = false)
{
global $gbl, $sgbl, $login, $ghtml;
$gbl->setSessionV("lx_add_return_url", "/display.php?" . $ghtml->get_get_from_current_post(null));
$cdesc = get_description($class);
$cdesc = $dttype ? $dttype['val'] : $cdesc;
if ($notitleflag) {
$title = null;
} else {
$title = "Add {$cdesc}";
}
$string[] = $ghtml->object_variable_startblock($object, $class, $title);
$string[] = $ghtml->object_inherit_classpath();
$string[] = $ghtml->object_variable_hidden("frm_o_cname", $class);
$string[] = $ghtml->object_variable_hidden("frm_dttype", $dttype);
$ret = exec_class_method($class, 'addform', $object, $class, $dttype);
if ($dttype) {
$ret['variable'][$dttype['var']] = array('h', $dttype['val']);
}
$string[] = create_xml($object, $class, $ret);
$vlist = $ret['variable'];
$pre = $post = null;
if (isset($vlist['__m_message_pre'])) {
$pre = $vlist['__m_message_pre'];
}
if (isset($vlist['__m_message_post'])) {
$post = $vlist['__m_message_post'];
}
$ghtml->print_information('pre', 'addform', $class, $dttype['val'], $pre);
$ghtml->xml_print_page($string);
$ghtml->print_information('post', 'addform', $class, $dttype['val'], $post);
}
/**
* get_company_search
*
* @return string XML representation of the search results (list of companies ids that match the query)
*/
function get_company_search() {
// the obm var nams and the search parameters names may be different
$replacement = array('name' => 'name',
'number'=>'number',
'phone'=>'phone',
'zip'=>'zip',
'town'=>'town',
'country'=>'country',
'type'=>'type',
'activity'=>'activity',
'naf'=>'naf',
'datasource'=>'datasource',
'market'=>'market',
'date_after'=>'date_after',
'date_before'=>'date_before'
);
$field_list = array('company_id' => 'company_id',
'company_name' => 'company_name',
'company_number' => 'company_number',
'company_nafcode_id' => 'company_isin',
'company_address1' => 'company_address1',
'company_address2' => 'company_address2',
'company_address3' => 'company_address3',
'company_town' => 'company_town',
'company_zipcode' => 'company_zipcode',
'country_name' => 'company_country',
'company_phone' => 'company_phone',
'company_fax' => 'company_fax',
'company_email' => 'company_email',
'company_web' => 'company_web'
);
$get=array();
$root_node='listing';
$multi_search = false;
$require_fields = array();
//permet de récupérer les champs qu'il faut affiché
$field_list = prepare_field_list($_GET,$field_list);
foreach($replacement as $key => $value){
if(isset($_GET[$value])){
$get[$key]=$_GET[$value];
}
}
//recupère tous les critères pour le recherche multiple
$multi_search = search_multicritere($get,&$multicritere,&$champ);
$datas = array();
//Si c'est une recherche multicritere on recupere les informations
//pour chaque critère
if($multi_search){
$root_node='multisearch';
foreach($multicritere as $val){
//a chaque critère on modifie le champ
$get[$champ]=$val;
$data = get_company_mono_search($get,$field_list);
if(!empty($data)){
//on fusionne les information que l'on as déjà avec les
//nouvelles pour evité les doublons
$datas=array_merge($datas,$data);
}
}
} else {
$field_list=array('company_id' => 'company_id');
$datas=get_company_mono_search($get,$field_list);
}
// if no datas, return
if (count($datas) == 0) {
return ;
}
return create_xml($datas,$root_node,'company',$multi_search);
}
//получаем список таблиц из БД для выпадающего меню
$tables = get_tables($conn);
if ($_POST) {
$name = $_POST['tables'];
$format = $_POST['formats'];
$m_format = strtolower($format);
if (in_array($name, $tables)) {
switch ($format) {
case "CSV":
create_csv($name, $conn);
break;
case "JSON":
create_json($name, $conn);
break;
case "XML":
create_xml($name, $conn);
break;
default:
echo "<h3>Выберите формат файла!</h3>";
break;
}
//проверяем существование файла
$file = DIR . $m_format . "/" . $name . "." . $m_format;
if (file_exists($file)) {
download_file($file);
}
} else {
echo "<h3>Выберите таблицу из списка!</h3>";
}
}
?>
if (!isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$user = md5($_SERVER['REMOTE_ADDR']);
} else {
$user = md5($_SERVER['HTTP_X_FORWARDED_FOR']);
}
if (isset($_POST['song']) && isset($_POST['name']) && isset($_POST['set'])) {
$song = $_POST['song'];
$name = $_POST['name'];
$set = $_POST['set'];
if (file_exists($settings)) {
if (validate_values($song, $name, $set, $settings)) {
if (file_exists($xmlFile)) {
update_xml($user, $song, $name, $set, $xmlFile);
echo "update";
} else {
create_xml($user, $song, $name, $set, $xmlFile);
echo "create";
}
} else {
echo "not valid";
}
} else {
echo "settings not found";
}
}
function validate_values($song, $name, $set, $settings)
{
$found = false;
$xml = new DOMDocument('1.0', 'utf-8');
$xml->preserveWhiteSpace = true;
$xml->load($settings);
/**
* get_contact_search
*
* @return string XML representation of the search results (list of contact ids that match the query)
*/
function get_contact_search() {
// the obm var nams and the search parameters names may be different
$replacement = array('fname' => 'firstname',
'lname' => 'lastname',
'privacy' => 'privacy',
'number'=>'number',
'phone'=>'phone',
'email'=>'email',
'company'=>'company',
'zip'=>'zip',
'town'=>'town',
'country'=>'country',
'datasource'=>'datasource',
'function'=>'function',
'title'=>'title',
'market'=>'market',
'date_field'=>'date_type',
'date_after'=>'date_after',
'date_before'=>'date_before',
);
$field_list = array('contact_id' => 'contact_id',
'contactfunction_label' => 'contact_function',
'contact_firstname' => 'contact_firstname',
'contact_lastname' => 'contact_lastname',
'kind_minilabel' => 'contact_genre',
'contact_title' => 'contact_title',
'contact_service' => 'contact_office',
'contact_address1' => 'contact_address1',
'contact_address2' => 'contact_address2',
'contact_address3' => 'contact_address3',
'company_town' => 'company_town',
'company_zipcode' => 'company_zipcode',
'company_country_name' => 'company_country',
'company_phone' => 'company_phone',
'company_fax' => 'company_fax',
'contact_email' => 'contact_email'
);
$get=array();
$root_node='listing';
$multi_search = false;
$require_fields = array();
$field_list = prepare_field_list($_GET,$field_list);
foreach($replacement as $key => $value){
if(isset($_GET[$value])){
$get[$key]=$_GET[$value];
}
}
$multi_search = search_multicritere($get,&$multicritere,&$champ);
$datas = array();
if($multi_search){
$root_node='multisearch';
foreach($multicritere as $val){
$get[$champ]=$val;
$data = get_contact_mono_search($get,$field_list);
if(!empty($data)){
$datas=array_merge($datas,$data);
}
}
} else {
$field_list=array('contact_id' => 'contact_id');
$datas=get_contact_mono_search($get,$field_list);
}
// if no datas, return
if (count($datas) == 0) {
return ;
}
return create_xml($datas,$root_node,'contact',$multi_search);
}
